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;

How many types of triggers exist in pl/sql?

1009

---

what are all the different normalizations? : Sql dba

960

---

What is a clob in sql?

967

---

Can we use views in stored procedure?

968

---

When sql appeared?

1023

---

How do I run pl sql in sql developer?

1059

---

Can a table have no primary key?

1009

---

How subquery works in sql?

994

---

how would you enter characters as hex numbers? : Sql dba

935

---

What is sql procedures and functions?

955

---

What is the default isolation level in sql server? : Transact sql

962

---

Which software is used for pl sql programming?

929

---

what happens if null values are involved in expressions? : Sql dba

1000

---

How do you update a value in sql?

985

---

Explain what is a column in a table?

1041

---