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;

In what condition is it good to disable a trigger?

556

---

What is a recursive stored procedure?

621

---

What is count * in sql?

558

---

What is a temporal data type?

599

---

What are sql injection vulnerabilities?

500

---

---

How do you get column names only for a table (sql server)?

671

---

What is program debugging?

568

---

how can we know the number of days between two given dates using mysql? : Sql dba

548

---

Can instead of triggers be used to fire once for each statement on a view?

541

---

Why are sql stored procedures used?

617

---

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

620

---

How to run pl/sql statements in sql*plus?

594

---

What is sql table?

522

---

What is native sql query?

554

---

what are the authentication modes in sql server? : Sql dba

537

---