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 difference between drop and truncate commands?

1062

---

What is a heap in sql?

1072

---

what is innodb? : Sql dba

1106

---

What is Collation Sensitivity ? What are the various type ?

952

---

Which table is left in join?

979

---

What is left join in postgresql?

1048

---

what is 'mysqldump'? : Sql dba

1109

---

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

962

---

what are different types of collation sensitivity? : Sql dba

1067

---

How can we optimize a sql query?

1052

---

How do I view stored procedures?

976

---

Can we edit a view in sql?

984

---

What is nosql vs sql?

1179

---

What is denormalization in a database?

1054

---

What is character functions?

1062

---