Is it possible to execute a dynamic sql from forms?
- 1 Answers
- 1161 Views
- I also Faced
- E-Mail Answers
Answer Posted / Manoranjan Kumar
Yes, it is possible to execute Dynamic SQL from Oracle Forms using the DBMS_SQL package. This allows you to dynamically construct and execute SQL statements.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement
