Home » Developer & Programmer » Forms » how can i make dynamic select
how can i make dynamic select [message #78820] Tue, 19 March 2002 00:42 Go to next message
devendra pathak
Messages: 1
Registered: March 2002
Junior Member
how can i make select statement if i have created table using forms_ddl in form
Re: how can i make dynamic select [message #78823 is a reply to message #78820] Tue, 19 March 2002 01:18 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
use dymanic sql techinque , u can opt for one of these
1. u can use ref cursor
2. u can use dbms_sql
3. u can use execute_immdeiate
4. u can use forms_ddl , but u have to create a pl/sql block.
Previous Topic: Default WHERE String on New Form Instance
Next Topic: foreign key
Goto Forum:

Current Time: Fri May 24 01:50:27 CDT 2024