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 create table with in the procedure or function?

Answer Posted / k.l.tharangini

create table using procedure

create procedure test as
begin
EXECUTE IMMEDIATE
'CREATE TABLE emp(empno VARCHAR(10),JOB VARCHAR(10),SAL
NUMBER(10))';
end;

Is This Answer Correct ?    43 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the max nvarchar size?

897


What is data modelling in sql?

962


Why is sharding used?

940


how do you control the max size of a heap table? : Sql dba

921


How do I quit sql?

897


Does sql use python?

974


What are pl/sql cursors?

989


What are all the different normalizations?

970


What plvcmt and plvrb does in pl/sql?

1249


What is the example of procedure?

874


What type of join is sql join?

922


How does rowid help in running a query faster?

1368


What is dialect in sql?

888


Why do we use function in pl sql?

1006


how many ways to get the current time? : Sql dba

948