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

How to call DDL statements from pl/sql?

Answer Posted / santosh kumar

declare
v_ddl_stat varchar2(200):='create table '||'&table_name'||'
('||'&column_names'||')'; --col_name like(eid number(5),name
varchar2(10))
begin
EXECUTE IMMEDIATE v_ddl_stat;
END;
/

Is This Answer Correct ?    8 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are all the different normalization?

1036


What are the benefits of triggers?

1164


How do you optimize a stored procedure in sql?

941


What is the basic structure of an sql?

1095


what are all the different normalizations? : Sql dba

1029


How to select unique records from a table?

1051


What is the difference between microsoft access and sql?

1012


What is crud stand for?

992


how can you see all indexes defined for a table? : Sql dba

986


What are dml commands?

1014


Is pl sql useful?

983


What are sql ddl commands?

1082


what is a scheduled jobs or what is a scheduled tasks? : Sql dba

955


What are the types of join and explain each?

1029


What does sign mean sql?

1087