Forms :: Marquee Effect In Text
Mar 15, 2011Is it Possible to get Marquee Effect in Form Text ?
View 9 Replies
ADVERTISEMENT
Forms :: Is There Text Changed Trigger With Text Item Function
May 5, 2010Is there text changed trigger with text item function like when_list_changed trigger of list item?
View 7 Replies View RelatedForms :: MS Word Rich Text Format In Text Item
Apr 17, 2012Can I use rich text item on oracle form10G with some simple features like BOLD, UNDERLINE, ITALIC and if possible one more feature like spell check.
I Google my requirement, but mostly I found win word attachment. Further more if I can save this type of data in field then how can I print in report.
Forms :: Text Box To Accommodate Large External File Text
Dec 30, 2010I have a requirement in one of my forms screen.I have a text box(large text area) which should display a help text file when i move my cursor on the topics displayed on the screen.know the code and the properties to be changed in the text box to accommodate large external file text.
View 1 Replies View RelatedSetting New Sub Partition Template Has No Effect
Oct 19, 2010Not sure if its an issue or just an Oracle "feature" of some sort. So I create a table with a specified partition/ sub partition template as follows:
CODEcreate table sr_part_test
(
part_key NUMBER,
subpart_key VARCHAR(10)
)
tablespace NORKOM_DATA
partition by range ( part_key )
subpartition by list ( subpart_key )
[code].......
Then when I split the MAX VALUE partition, all is hunky dorey and as expected:
CODEalter table sr_part_test split partition sr_part_max at (4) into
(
partition sr_part_4,
partition sr_part_max
);
select * from user_tab_subpartitions where table_name = 'SR_PART_TEST' and partition_name = 'SR_PART_4';
[code]......
But - what if I want to have new generated names and possibly even new subpartition keys? Won't work:
CODEalter table sr_part_test
set subpartition template
(
subpartition sp_1_NEWNAME values ('foo'),
subpartition sp_2_NEWNAME values ('bar'),
subpartition sp_3_NEWNAME values ('baz')
);
[code]........
Notice that the sub partition names are still using the old names (which I do NOT want), and still using the old keys! C .
SQL & PL/SQL :: Effect Of Truncate On Associated Indexes Of Tables?
Jul 21, 2012I know that truncate is a ddl operation that removes all the data from the table and set the HWM to very beginning. I am curious to know, is anyhow indexes will be affected on the issuance of truncate command or we need to rebuild the indexes after issuing truncate.
Also is there any way to know that how many rows/blocks a select statement is scanning because of the effect of HWM even the table has 0 rows.
SQL & PL/SQL :: Index Effect While Inserting Records In A Table
Dec 17, 2011I have one indexed column in a table.for performance improval purpose i created index to that column .
my doubt is..it may decrease the performance while inserting data into that column?
Auto Accounting Rule Is Not Taking Effect In PROD
Aug 10, 2013we are in the migration of oracle apps 11.5.9 [version] , while uploading AR open invoices we used auto accounting rule for revenue account , but we did this changes its not taking an effect , same revenue a/c we uploaded is uploaded , but the auto accounting is not taking an effect ,
for a work around we migrated the data ! but we would be the root cause and possibilities why it hasn't worked ?
But this auto accounting rule worked in CRP & UAT as well ...!!!
Backup & Recovery :: Effect Of Insert On Export (expdp)
Apr 19, 2012What will be the effect of insert statement on expdp if I am doing full table export?
View 4 Replies View RelatedServer Administration :: Initialization Parameter File - Currently In Effect For Session
Jan 31, 2012I have a question about spfile.
SQL> SELECT COUNT(*) FROM v$parameter WHERE value IS NOT NULL;
COUNT(*)
----------
246
SQL> SELECT COUNT(*) FROM v$spparameter WHERE value IS NOT NULL;
COUNT(*)
----------
20
v$parameter displays information about the initialization parameters that are currently in effect for the session,but v$spparameter displays information about the contents of the spfile.I want to know why the count of parameters whose values are not null in v$parameter is greater.where are they from? My initialization parameter file is spfile.
Data Guard :: Truncate Table Effect On Physical Standby
Nov 20, 2009Are there redo generate during truncate operation even my primary database is in FORCE LOGGGING mode? How this will effect on physical standby database.
View 6 Replies View RelatedForms :: Export Text File With Same File As Imported Text File?
May 30, 2011Is it possible to get the same name of file name from imported text file?
What i've is, I import the text file then I exported it.
can I get the same name of the imported text file?
Forms :: Export Text File From Oracle Forms
Oct 9, 2010Exporting text data from a table. Suppose I have a table of employees.
In oracle Forms. I make the two column of Hire_date1 and Hire_date2. When I put the Date Into Hire_date1 and Hire_date2 , And press push button. All the data save in text file C: emp folder.
Forms :: Text Item In Oracle Forms
Aug 22, 2010How to get the value of text item in Oracle forms to pass as a parameter in stored procedure.
View 4 Replies View RelatedApplication Express :: Prefix Text Entered Into Text Area With Userid And Timestamp?
Sep 12, 2012Have got basic form on a table and have a textarea which holds Notes added by user.
So Notes database field is updated on Save / Apply changes button being pressed.But would really like any text added / appended to the Notes field to be prefixed by userid and date / timestamp.
Is it possible via dynamic actions or Javascript to have any new text added / typed to be auto prefixed as per above.
Would only want the first key press in the filed to trigger the auto-prefix and if added text was deleted then the auto prefix to be deleted as well ?? If user doesn't press Save / Apply changes obviously want to leave existing Notes as is.
Text :: Index Memory Parameter For Oracle Text Indexes
Sep 17, 2013I am on Oracle 11.2.0.3 on Linux and have implemented Oracle Text.I created Oracle Text indexes with default setting. However in an oracle white paper I read that the default setting may not be right. Here is the excerpt from the white paper by Roger Ford:URL....(Part of this white paper below....)Index Memory.
As mentioned above, cached $I entries are flushed to disk each time the indexing memory is exhausted. The default index memory at installation is a mere 12MB, which is very low. Users can specify up to 50MB at index creation time, but this is still pretty low. This would be done by a CREATE INDEX statement something like: CREATE INDEX myindex ON mytable(mycol) INDEXTYPE IS ctxsys.context PARAMETERS ('index memory 50M'); Allow index memory settings above 50MB, the CTXSYS user must first increase the value of the MAX_INDEX_MEMORY parameter, like this: begin ctx_ adm. set_ parameter('max_index_memory', '500M'); end; The setting for index memory should never be so high as to cause paging, as this will have a serious effect on indexing speed. On smaller dedicated systems, it is sometimes advantageous to temporarily decrease the amount of memory consumed by the Oracle SGA (for example by decreasing DB_CACHE_SIZE and/or SHARED_POOL_SIZE) during the index creation process.
Once the index has been created, the SGA size can be increased again to improve query performance." (End here from the white paper excerpt)My question is:
1) To apply this procedure (ctx_adm.set_parameter) required me to login as CTXSYS user. Is that right? or can it be avoided and be done from the application schema? This user CTXSYS is locked by default and I had to unlock it. Is that ok to do in production?
2) What is the value that I should use for the max_index_memory should it be 500 mb - my SGA is 2 GB in Dev/ QA and 3GB in production. Also in the index creation what is the value I should set for index memory parameter - I had left that at default but how should I change now? Should it be 50MB as shown in example above?
3) The white paper also refer to rebuilding an index at some interval like once in a month: ALTER INDEX DR$index_name$X REBUILD ONLINE; We are on Oracle 11g and the white paper was written in 2003.
SQL & PL/SQL :: Converting HTML Format Text To Plain Text?
Dec 23, 2009Is there any way to convert HTML format text to Plain Text ?
View 26 Replies View RelatedForms :: Set Run Time Initial Value Of Text Box
Jun 4, 2010I want set run time initial value of text box...?
what property need to use for that..?
Forms :: How To Add Text Items At Runtime
Dec 24, 2012I want add a text item at run time depending on the number of values retrieved i want to change the number of text items. Is it possible at run time to add a text item?
View 1 Replies View RelatedForms :: Verification Of Item Text?
Mar 19, 2013I want to make a verification of an item text ,the user must enter a number of length 4. So I created a text item :number(4). and in when-validate-item trigger of this item ,I put this
if length(:block.empno) != 4 then
message('this item must containonly 4 digit');
end if;
=> the problem, when the user entered "0123" ,it should be acceptable !! but this is not the case ...
Forms :: How To Set Text Item Transparent In 6i
Dec 21, 2011I am having Forms with background image on the canvas. now my problem is, how can i set a text item to be transparent so that the background image can be seen as clear as when there is no text item on it.
View 6 Replies View RelatedForms :: How To Insert Bullets In Text
Dec 21, 2010I am using oracle database 10.2.0.1.0 with oracle developer 10.1.2.0.2 on windows xp.I have a assignment in which i have to insert data in text field using bullets.Means user would like to use bullets while inserting data in text field.How can i use bullet option (as we have in MS word) in oracle forms.
View 5 Replies View RelatedForms :: Blink Text In Oracle 6i
Dec 30, 2011I am using oracle forms 6i. In my form having Headline Text. I want to change the color text every one 1 sec.
View 5 Replies View RelatedForms :: 6i / Validating Text Items?
Nov 24, 2010I am working on form 6i.
i need to write validation on text fields like first name,last name,phone no,email id
i have to not allow special char.
Forms :: How To Hide Text Prompt
Jul 27, 2011I have created a text prompt in layout editor by clicking a button 'TEXT'('A' symbol) from left hand side toolbar,text is created with name 'TEXT67' and graphics type 'TEXT'.
when i click that text(TEXT67),block showing <null>.
So i cant use the below code,bcoz no block for that text..
SET_ITEM_PROPERTY('<BLOCK_NAME>.<TEXT_NAME>',PROMPT_TEXT,' ');
then i tried below,i.e i skip block name i gave only text name..
SET_ITEM_PROPERTY('TEXT67',PROMPT_TEXT,' ');
not working...
Forms :: Pre-text-item Trigger?
Nov 17, 2008In my form, for an item there is code for pre-text-item trigger. In query mode when i go to next record, previous record etc, whether this trigger gets fired? In other forms it is getting executed. Only in this form it is not getting executed. What should be reason for not executing this pre-text-item? Only this item is enabled and cursor is there.
View 9 Replies View RelatedForms :: Key Press In Text Item
Oct 9, 2010A form with two text fields text1 and text2. Now i want to enter text value in the text1 field and subsequently this value entered into text2. i.e if i want to press x in text1 it also in the text2. if i want to press y in text1 it also in the text2. and so on without using enter key.
View 3 Replies View RelatedForms :: How To Change Color Of Text
Mar 13, 2012i want to change the text background color as red ex: if desc is the field in the forms and when i type the word china in that field then that china backgroud color should change when i move to next item to red for that record alone..in the key_next_item trigger i wrote this
set_item_property('desc' backgroud_colour,'RED');
IS THIS RIGHT only that particular record should change
Forms :: Use Text Tool In Programming?
Feb 3, 2010Can i use Text tool in programming...
i just want to change color at run time of text tool....
i attached a picture must see...
Forms :: Text Display While Typing?
Sep 1, 2013i want something like auto-text in forms 6i in list box if user is enter M then words related to M , Middle east, Michael, Mexico should appear and user will have the option to select from this three options , if he presses m and then e only mexico should appear.How i can achieve this.
View 4 Replies View Related