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

Is rowid unique in oracle?

993

what are the default admin accounts in Oracle 10g ?

963

Define oracle database

1038

What is oracle host variable?

1048

What is the data pump import utility?

1027

What is a read only transaction in oracle?

1016

what is the difference between restoring and recovering?

1009

What is using clause and give example?

1027

List the various oracle database objects?

1048

What is an oracle transaction?

1125

Explain compound trigger in oracle?

1024

How to rename an index?

1063

How to change user password in oracle?

1019

How to change program global area (pga) in oracle?

1080

definition of cluster and non-clustered index?

3021