Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

What is different bet native dynamic sql and Dbms_Sql?

Question Posted / s.gousalya

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

Explain the use of show option in imp command.

1142

State and explain about oracle instance?

1048

What are the ansi data types supported in oracle?

986

Explain the use of owner option in exp command.

1095

What to do if the binary spfile is wrong for the default instance?

1106

does the query needs a hint to access a materialized view?

1905

What is oracle rowcount?

1143

What is partitioned table in Oracle?

1266

What is the difference between truncate & delete command?

1232

Explain cascading triggers.

1118

How to create a new table in oracle?

1228

what is the difference between substr and instr function in oracle?

1139

What are the most common interview questions on ETL Testing for experience?

1187

What are the execution control statements?

1107

How to use "while" statements in oracle?

1374