| DynamicQuery [message #81885] |
Sat, 29 March 2003 09:57  |
jan
Messages: 71
Registered: August 2002
|
Member |
|
|
i want to search by
having field like Name then afield named operator and then a field name criteria
eg :name :operator (list ofoperators) and then criteria eg 'jan'.
any body willhelpme.
thanx in advance.
|
|
|
|
| Re: DynamicQuery [message #81895 is a reply to message #81885] |
Sun, 30 March 2003 23:21  |
utsav
Messages: 94
Registered: March 2003
|
Member |
|
|
Hi,
well u can do this but obviously only one operator will be applicable at one time.
If its from forms use the forms_ddl orexecute_immediate.
In pl/sql just use the execute_immediate.
TRy it, in case of problems do let me know.
utsav
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
