how can end user can create table from front end,
how can end user can create table from front end,
❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up and it is 100% FREE.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
OrclQA.Com is a question and answer forum for programmers.
Here anyone can ask questions and anyone can answer to help others.
It hardly takes a minute to sign up and it is 100% FREE.
Vinish Kapoor
Give an option to the user to specify table name and columns, then you can prepare a string (Create Table command) and can execute using dynamic SQL (execute immediate or dbms_sql).
Ali Akbar
DECLARE
ddl_qry VARCHAR2 (150);
tbname varchar2(100);
col1 varchar2(50);
dtype1 varchar2(50);
scale1 varchar2(10);
col2 varchar2(50);
dtype2 varchar2(50);
scale2 varchar2(10);
BEGIN
tbname := :P3_NEW_6;
col1 := :P3_NEW;
dtype1 := :P3_NEW_1;
scale1 := :P3_NEW_4;
col2 := :P3_NEW_2;
dtype2 := :P3_NEW_3;
scale2 := :P3_NEW_5;
ddl_qry := 'CREATE TABLE tbname(
col1 dtype1(scale1),
col2 dtype2(scale2)
)';
EXECUTE IMMEDIATE ddl_qry;
END;
sir my syntax is ok but when press create button then show error
Error: Ajax call returned server error ORA-00907: missing right parenthesis for Execute PL/SQL Code.
Ali Akbar
Done
thanks sir