What is different bet native dynamic sql and Dbms_Sql?
- 4 Answers
- 14819 Views
- Thermotech, I also Faced
- E-Mail Answers
Answer Posted / thirupathi.l
using native dynamic sql we can directly use DML and DDL
statements.
ex:native dynamic sql
declare
a varchar2(1000);
begin
a:='create table <tname>(elements)
execute immediate a;
end;
where as in dbms_sql package also we can use dml and DDL
but here declare cursor
coding is so lenthy
thats why currently using native dynamic sql
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
Explain the use of inctype option in exp command.
What is ADDM Advisor in Oracle?
How to handle a single quote in oracle sql?
What is an oracle user role?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What is the difference between post-database commit and post-form commit?
Describe the types of sub query?
What is the usage of control file in oracle?
Give the various rollback segment states.
What are the different pseudo commands? Explain in general?
What is object data modeling?
How do we get field details of a table?
How do I know if oracle is installed on windows?
What is query image?
What is an oracle function?
