How to create table using procedure in pl/sql?

Answer 1

SET SERVEROUTPUT ON
SET ECHO OFF
CREATE OR REPLACE PROCEDURE createS(
inE# IN NUMBER(2), inName IN VARCHAR(2) )IS BEGIN --create STUDENT table CREATE TABLE STUDENT( E# NUMBER(12) NOT NULL, NAME VARHCAR2, CONSTRAINT STUDENT_PK PRIMARY KEY(E#)); COMMIT; END createS; /

Answer 2

what is the fuction of echo off?

Answer 3

your above query was got compiled error.
how you mentioned create table within another create?
is it possible

Answer 4

If echo is set to off, SQL statements that are run will not be displayed while setting echo to on will display them.

BEGIN
EXECUTE IMMEDIATE 'create table my_table (n number)';
END;

Answer 5

tnx....
my another doubt is what is pivot and un pivot and what's the usage?