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 an exception in pl/sql?

725

---

What is native sql query?

732

---

Explain the components of sql?

788

---

How do I add a database to sql?

776

---

Why we use sql profiler?

721

---

---

Which data dictionary views have the information on the triggers that are available in the database?

938

---

Mention what are the benefits of pl/sql packages?

731

---

Which is better stored procedure or query?

719

---

how to convert character strings to numeric values? : Sql dba

771

---

What is sql stand for?

740

---

What is the primary key?

698

---

What are types of exception?

686

---

What is sql*loader?

757

---

How do I create a sql database?

710

---

What is sqlexception in java?

728

---