Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa SQL How we can create a table through procedure ?
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


hemant kumar
How we can create a table through procedure ?
1 Answer(s)      4 years and a month ago
Posted in : SQL


How we can create a table through procedure ?


Advertisement
View Answers

November 19, 2010 at 5:19 PM


Hi,

we can create table with procedure by using 'EXECUTE IMMEDIATE' command.

EXECUTE IMMEDIATE
'CREATE TABLE ' || 'EMP_' || loc ||
'(
empid NUMBER(4) NOT NULL
ename VARCHAR2(10)
empjob VARCHAR2(9)
empsal NUMBER(7 2)
empdeptno NUMBER(2)
)';

Thanks,



Related Tutorials/Questions & Answers:
 

 

 

DMCA.com