Native Dynamic sql: Directly we can include sql code into our query or

What is different bet native dynamic sql and Dbms_Sql?

Question Posted / s.gousalya

4 Answers
16758 Views
Thermotech, I also Faced
E-Mail Answers

Answer Posted / s.gousalya

Native Dynamic sql:
Directly we can include sql code into our query or
procedure using EXECUTE IMMEDIATE

DBMS_SQL it offers an API that execute SQL statement
dynamically.

Is This Answer Correct ?

0 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is rowid and rownum in oracle?

1069

What are the four Oracle system processes that must always be up and running for the database to be useable?

1051

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

3097

What is meant by raw datatype?

1118

What is a table in oracle?

1022

How to best split csv strings in oracle 9i?

1098

various types of hints and their usage

2749

What is merge statement used for?

1075

Why do you create or replace procedures rather that drop and recreate.

1070

What is ADDM Advisor in Oracle?

1224

How to convert character types to numeric types?

1193

How to drop a stored procedure in oracle?

1105

Explain the use of ignore option in imp command.

1086

What are the ways tablespaces can be managed and how do they differ?

2446

What are the different types of synonyms?

1198