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

Report message to a moderator

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.

Report message to a moderator

Previous Topic: Default WHERE String on New Form Instance
Next Topic: foreign key
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 04:46:55 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.