Answer Posted / parag tyagi

CREATE OR REPLACE PROCEDURE emp_test( in_name VARCHAR2) IS
cnt NUMBER;
BEGIN
EXECUTE IMMEDIATE ('grant create table to user_name');
EXECUTE IMMEDIATE ('create table ' || in_name || '(name
varchar2(10))');
SELECT '1' INTO cnt FROM User_Objects WHERE object_name
= 'EMP_TEST';
IF cnt IS NOT NULL THEN
dbms_output.put_line('Table Created');
END IF;
EXCEPTION
WHEN OTHERS THEN
dbms_output.put_line('Name is already used by an existing
object');
END;

What is the usage of when clause in trigger?

1087

---

How do I enable sql encryption?

1072

---

what are the non-standard sql commands supported by 'mysql'? : Sql dba

1173

---

How many types of normalization are there?

1013

---

What are types of exception?

963

---

Why is sql*loader direct path so fast?

1141

---

What is the difference between jpql and sql?

1143

---

What are the various restrictions imposed on view in terms of dml?

1017

---

What is primary key and foreign key?

1011

---

What is a recursive join sql?

1112

---

what is a cursor? : Sql dba

1064

---

What is bulk collect in pl sql?

1157

---

What are the properties of a transaction?

1185

---

What is the sql case statement?

1053

---

How to start the command-line sql*plus?

1109

---