HELO !
Please HELP me SOON in creating table in procerdure i write the following statment but it gives error
CREATE OR REPLACE
PROCEDURE EMP_BACK_UP_SAL ARY
(param IN VARCHAR2) AS
BEGIN
CREATE TABLE a AS (SELECT * FROM b);
END;
Error
"Encountere d the symbol CREATE while expecting the following like BEGIN CASSE DECLARE ETC"
Please HELP me SOON in creating table in procerdure i write the following statment but it gives error
CREATE OR REPLACE
PROCEDURE EMP_BACK_UP_SAL ARY
(param IN VARCHAR2) AS
BEGIN
CREATE TABLE a AS (SELECT * FROM b);
END;
Error
"Encountere d the symbol CREATE while expecting the following like BEGIN CASSE DECLARE ETC"
Comment