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

Does oracle use sql?

907


What is orm in sql?

1030


Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1245


How much ram can sql express use?

964


What is coalesce in sql?

1034


Does group by remove duplicates?

1020


how many columns can be used for creating index? : Sql dba

932


what is a record in a database ? : Sql dba

1045


What steps server process has to take to execute an update statement?

962


What is latest version of sql?

1027


What are all different types of collation sensitivity?

1014


What is sql*loader and what is it used for?

1119


What are reports usually used for?

1006


What is localdb mssqllocaldb?

1052


What is nvarchar max in sql?

994