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;

Does mysql support pl sql?

1176

---

What is pragma in sql?

1085

---

Why having clause is used in sql?

982

---

What is trigger in sql? Explain

999

---

What is view explain with example?

936

---

What are the different set operators available in sql?

1026

---

What is data profiling in sql?

1084

---

Does execute immediate commit?

1223

---

What is the difference between a query and a report?

978

---

how many ways we can we find the current date using mysql? : Sql dba

1100

---

What is localdb mssqllocaldb?

1070

---

What are all the different normalization?

1044

---

How do I filter in sql profiler?

999

---

What is the plv (pl/vision) package offers?

1054

---

What are the different types of sql commands?

1128

---