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 is a primary key sql?

1093

---

How do you know if a relationship is 2nf?

994

---

What is the usage of sql functions?

1202

---

How do I count rows in sql?

1048

---

Can I learn sql in a week?

1119

---

Name some usages of database trigger?

1082

---

What is the difference between union and union all command?

1151

---

How can I see all tables in sql?

1141

---

What is the difference between sql and t sql?

1106

---

what is a record in a database ? : Sql dba

1103

---

Does sql support programming?

1115

---

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

1131

---

what is data integrity? : Sql dba

1086

---

Can there be 2 primary keys in a table?

1042

---

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

1005

---