Use of "Order by" clause dynamically in LOV on oracle 10g forms [message #406693] |
Fri, 05 June 2009 07:00  |
manojbaghel
Messages: 2 Registered: June 2009 Location: Delhi
|
Junior Member |

|
|
Hi Guys,
I have a requirement on the use of lov on the forms.
Requirement is like this
1. Create a List Of Values with 2 fields, Code and Description
2. Do not use order by clause in record Group Query
3. Attach this LOV to a field in Form
4. When user invokes the LOV user will see two fields in LOV with header as Code and Description
5. Now when user clicks on Column Header "Code" then LOV should be sorted on Code
6. And if User clicks on Column Header "Description" then LOV should be sorted on Description
If anybody has done like this,please suggest me with examples.
Thanks in advance.
|
|
|
|
|
|