Can we write create command in the plsql block?if possible
how?
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between null value, zero, and blank space?
Define commit, rollback and savepoint?
What are the rules to be applied to nulls whilst doing comparisons?
What is a database trigger?
Which are the different case manipulation functions in sql?
Why is stored procedure faster than query?
Why use truncate instead of delete?
Is postgresql a nosql database?
what is sql? : Sql dba
What are the types of sql commands?
How do rank () and dense_rank () differ?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
How many types of normalization are there?
What is data type in database?
is mysql query is case sensitive? : Sql dba