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;

Determine if oracle date is on a weekend?

981

---

What is a clob in sql?

966

---

what are the performance and scalability characteristics of mysql? : Sql dba

942

---

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

1957

---

What is the basic structure of an sql?

1031

---

What is restrict in sql?

1030

---

What is sql*loader and what is it used for? : aql loader

1093

---

What are the basic techniques of indexing?

1012

---

What is varchar used for?

1022

---

What is the difference between a query and a report?

900

---

Is nosql relational?

892

---

Explain the working of foreign key?

976

---

What schema means?

844

---

What are sql data types?

948

---

what is csv? : Sql dba

944

---