Answer Posted / kavitha nedigunta

set serveroutput on;
DECLARE
CNT NUMBER;
table_name varchar2(300) := 'testnew';
BEGIN
--EXECUTE IMMEDIATE ('grant create table to user_name');
EXECUTE IMMEDIATE ('create table '||table_name||'(name
varchar2(10))');

SELECT COUNT(*) INTO CNT FROM USER_OBJECTS WHERE OBJECT_NAME = upper(''||table_name||'');

IF cnt > 0 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 are commit, rollback, and savepoint?

983

---

explain normalization concept? : Sql dba

1041

---

what is the syntax used for partition in tsql? : Transact sql

1009

---

Can a table have no primary key?

1050

---

What are the different types of a subquery?

1044

---

how to convert dates to character strings? : Sql dba

1159

---

What is record data type?

908

---

What are the different types of database management systems?

995

---

what is sub-query? : Transact sql

1093

---

What do you mean by rowid?

971

---

What is the use of desc in sql?

972

---

How do I remove sql plus from windows 10?

1087

---

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

2012

---

What is function and procedure?

1023

---

What is the difference between inner join and left join?

979

---