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...

what are Dynamic SQL statements?

Answer Posted / vishal kumar

Sql statement should be written in quotes like

'select table1.col1, tabel2.col2 from table1,table2 where
table1.col3=table2.col4'
and we can execute through below command "execute immidiate"
EXECUTE IMMEDIATE 'select table1.col1, tabel2.col2 from
table1,table2 where table1.col3=table2.col4'

it execute at runtime, means its not allowed as static.

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by stored procedures? How do we use it?

1035


What is program debugging?

1341


what is blob? : Sql dba

1216


what is an index? : Sql dba

1039


I need a function for a train ticket reservation please answer it thanks in advance

1077


Explain constraints in sql?

1084


What is denormalization in a database?

1105


Explain what is table in a database?

1110


what is bcp? When is it used?

1177


What is sql and also describe types of sql statements?

1109


What is scalar function in sql?

1095


What do you mean by table in sql?

1045


How do I create a sql script?

1141


What is flag in sql?

1097


How can the performance of a trigger be improved?

1087