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: 19882
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 49 times)
Re: sql Function [message #605791 is a reply to message #605790] Tue, 14 January 2014 12:33 Go to previous message
BlackSwan
Messages: 23133
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: Wed Dec 17 17:15:00 CST 2014

Total time taken to generate the page: 0.16156 seconds