Forms :: How To Insert Bullets In Text

Dec 21, 2010

I 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


ADVERTISEMENT

Forms :: How To Insert Column Values Into Text Items

Dec 30, 2011

I have created the Textitem with five instances.

i am trying to assign column values to text item through query.

if my table contain one record,it shown in textitems.But if my table contains more records it is showing ora-1422 err.how to solve it.

View 1 Replies View Related

Forms :: Insert Value Into Text Field On Current Cursor Position?

Sep 30, 2013

I need to copy some text value in to a multi-line text item on the current cursor position.

View 8 Replies View Related

Forms :: Is There Text Changed Trigger With Text Item Function

May 5, 2010

Is there text changed trigger with text item function like when_list_changed trigger of list item?

View 7 Replies View Related

Forms :: MS Word Rich Text Format In Text Item

Apr 17, 2012

Can 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.

View 3 Replies View Related

Forms :: Text Box To Accommodate Large External File Text

Dec 30, 2010

I 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 Related

Insert Text In A Specified Format As Number (x / Y)

May 29, 2012

Im trying to insert a number specified by the format for ex. S999.99, but the original text is of the form S99999, is there any way i can insert the data which will store it in the DB with the datatype as Number(5,2), the decimal is not present in the supplied value(through PreparedStatement) but needs to be put while inserting into the DB.

P.S.- 'S' in S999.99 signifies the sign(+/-).

View 1 Replies View Related

Oracle 11.2 - Insert String Text?

Oct 28, 2012

when i insert string text in hebrew i see ????????? how to fix it ?

work on Oracle 11.2 on Oracle Developer using my C# program

View 3 Replies View Related

Insert Rows Based On Text Values?

Mar 22, 2007

I am an Oracle beginner and I am having some trouble with the following insert query.

I am inputting values into text boxes and then this is carried out as a trigger upon clicking a button.

INSERT INTO client VALUES(':student.txtclientid', ':student.txtclientname', ':student.clientaddress', 13564338);
INSERT INTO enrolment VALUES(':student.txtclientid', ':student.lstoccurrence', null, null);

The above text boxes are all working fine as I have viewed the values using the message command. My proplem is that if i leave the fields blank it inserts ':student.txtclientname' into the row, otherwise it returns "Could not insert record"

View 1 Replies View Related

Forms :: When Insert Detail The Data Insert Twice Time

Feb 27, 2012

when i tried to insert the details from oracle froms..the data inserts twice to the DB..

my table structure:

create table app_sri
(a_id integer primary key,
p_first_name varchar2(30),
p_last_name varchar2(20),
p_age number(3)
);

here a_id can be genarated through simple sequence(pid_seq)...
trigger on app_sri
create or replace trigger pid_trg

[Code]....

form insertion code..

Begin
insert into app_sri(null,'robo','Big',100);
commit
End;

the data inserted...but twice

what is the reason behind the double insertion?

View 8 Replies View Related

Forms :: Export Text File With Same File As Imported Text File?

May 30, 2011

Is 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?

View 2 Replies View Related

Forms :: Export Text File From Oracle Forms

Oct 9, 2010

Exporting 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.

View 4 Replies View Related

Forms :: Text Item In Oracle Forms

Aug 22, 2010

How to get the value of text item in Oracle forms to pass as a parameter in stored procedure.

View 4 Replies View Related

Application Express :: Prefix Text Entered Into Text Area With Userid And Timestamp?

Sep 12, 2012

Have 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.

View 5 Replies View Related

Text :: Index Memory Parameter For Oracle Text Indexes

Sep 17, 2013

I 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.

View 5 Replies View Related

SQL & PL/SQL :: Converting HTML Format Text To Plain Text?

Dec 23, 2009

Is there any way to convert HTML format text to Plain Text ?

View 26 Replies View Related

Forms :: Set Run Time Initial Value Of Text Box

Jun 4, 2010

I want set run time initial value of text box...?

what property need to use for that..?

View 2 Replies View Related

Forms :: How To Add Text Items At Runtime

Dec 24, 2012

I 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 Related

Forms :: Verification Of Item Text?

Mar 19, 2013

I 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 ...

View 12 Replies View Related

Forms :: How To Set Text Item Transparent In 6i

Dec 21, 2011

I 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 Related

Forms :: Blink Text In Oracle 6i

Dec 30, 2011

I 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 Related

Forms :: 6i / Validating Text Items?

Nov 24, 2010

I 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.

View 3 Replies View Related

Forms :: How To Hide Text Prompt

Jul 27, 2011

I 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...

View 2 Replies View Related

Forms :: Pre-text-item Trigger?

Nov 17, 2008

In 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 Related

Forms :: Key Press In Text Item

Oct 9, 2010

A 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 Related

Forms :: How To Change Color Of Text

Mar 13, 2012

i 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

View 14 Replies View Related

Forms :: Use Text Tool In Programming?

Feb 3, 2010

Can i use Text tool in programming...

i just want to change color at run time of text tool....

i attached a picture must see...

View 9 Replies View Related

Forms :: Text Display While Typing?

Sep 1, 2013

i 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

Forms :: Marquee Effect In Text

Mar 15, 2011

Is it Possible to get Marquee Effect in Form Text ?

View 9 Replies View Related

Forms :: Clearing The Text Item

Jun 26, 2013

I am working on oracle form to build a login page and i have successfully completed it. But to make it more perfect i want to clear the text_item in which the username and password is entered. i have even raised the alert as well but after closing the alert i want to clear the text item .

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved