Home » Developer & Programmer » Forms » sql Function
sql Function [message #605697] Mon, 13 January 2014 13:20 Go to next message
akarra
Messages: 15
Registered: August 2011
Location: Housston
Junior Member
how to create a function or query to get the data as follows
first column has 1.columndesc
second column should start with 1.1(col text)
third col should start with 1.1.1(col text)

text will be entered manually but the numbering should automatically populate in the apex text box.
please advise.
thanks very much.
Re: sql Function [message #605714 is a reply to message #605697] Mon, 13 January 2014 15:44 Go to previous messageGo to next message
Littlefoot
Messages: 18822
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
When, how & why will 1.1.1 turn into 2, or 2.1, or 3.2.5, or ...?
Re: sql Function [message #605764 is a reply to message #605714] Tue, 14 January 2014 07:49 Go to previous messageGo to next message
akarra
Messages: 15
Registered: August 2011
Location: Housston
Junior Member
sorry if i am not clear, in may applicatiion i have a column text as follows

1.text1
2.text2
3.text4

once i select any one of the above in my apex select list

the other columns Comments1, comments2 should be prefixed with the number i selected abouve following

1.1 Cooments1 1.1.1. comments2
1.2 Comments1 1.1.2. comments2
1.3 Comments1 1.1.3 Comments 3

the numbering should automatically populated in the textbox and the text will be entered manually.
i tried with regexp_replace and autonumbering but no luck please adivse.

Re: sql Function [message #605790 is a reply to message #605764] Tue, 14 January 2014 12:22 Go to previous messageGo to next message
akarra
Messages: 15
Registered: August 2011
Location: Housston
Junior Member
please find the attachment for more clarity.
  • Attachment: testcase.PNG
    (Size: 150.53KB, Downloaded 32 times)
Re: sql Function [message #605791 is a reply to message #605790] Tue, 14 January 2014 12:33 Go to previous message
BlackSwan
Messages: 21938
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Previous Topic: decode in formula column in oracle form
Next Topic: background page problem
Goto Forum:
  


Current Time: Thu Apr 17 09:01:55 CDT 2014

Total time taken to generate the page: 0.26385 seconds