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

Can we use bind variables in oracle stored procedure?

899

What are the various constraints used in oracle?

993

What is index-organized table in Oracle?

1021

What is catalog in Oracle?

1265

What is literal?

956

What is the dynamic sql in oracle?

1008

How to create a table interactively?

998

What is snapshot is too old? Give and example for better understand.

1546

How do I recompile a procedure in oracle?

912

Explain the difference between a procedure and a function?

1091

What is hot backup and logical backup?

1002

Explain the difference between sap and oracle?

975

can anyody please send me the dump for Oracle 10g certifications for DBA path?

2090

How to delete multiple rows from a table in oracle?

1005

How to turn on or off recycle bin for the instance?

1012