OraFAQ Forum: Forms » sql Function

Home » Developer & Programmer » Forms » sql Function

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

sql Function [message #605697]

Mon, 13 January 2014 13:20

akarra
Messages: 24
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.

Report message to a moderator

Re: sql Function [message #605714 is a reply to message #605697]

Mon, 13 January 2014 15:44

Littlefoot
Messages: 21825
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 ...?

Report message to a moderator

Re: sql Function [message #605764 is a reply to message #605714]

Tue, 14 January 2014 07:49

akarra
Messages: 24
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.

Report message to a moderator