Can we write create command in the plsql block?if possible
how?
Answers were Sorted based on User's Feedback
Answer / umadevi
yeah the above answer is correct..
begin
execute immediate 'create table tablename(column_name
coloumn_type(coloumn_length))';
end;
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / sidh
Yes We can write a create command in a PL/SQL block using
dynamic SQL
eg Execute immediate 'create table tab_name....'
| Is This Answer Correct ? | 8 Yes | 0 No |
Explain what is sql?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
Does sap use sql?
What is TABLE SPACE?
What do you mean by dbms? What are its different types?
What is sqlservr exe?
Is sql harder than python?
How many types of indexes are there in sql?
Why should I use postgresql?
What is sqlite format?
how do you login to mysql using unix shell? : Sql dba
Tell me what a package consists of.
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)