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 the most restrictive isolation level? : Transact sql

540

---

how to load data files into tables with 'mysqlimport'? : Sql dba

510

---

What is left join example?

494

---

How do I enable sql encryption?

509

---

What is sql engine in oracle?

510

---

---

What is auto increment feature in sql?

609

---

Differentiate between pl/sql and sql?

605

---

What is a database? Explain

585

---

What is the location of pre_defined_functions.

632

---

Differentiate between syntax and runtime errors.

631

---

What is plpgsql language?

521

---

Explain the types of joins in sql?

563

---

how can you create an empty table from an existing table? : Sql dba

648

---

How many disk partitions should I have?

540

---

Which software is used for pl sql programming?

513

---