Answer Posted / k.l.tharangini

create table using procedure

create procedure test as
begin
EXECUTE IMMEDIATE
'CREATE TABLE emp(empno VARCHAR(10),JOB VARCHAR(10),SAL
NUMBER(10))';
end;

What are the advantages of stored procedure?

1037

---

What are field types?

1049

---

what are ddl statements in mysql? : Sql dba

1258

---

What is gpt format?

985

---

Can we use views in stored procedure?

1081

---

Explain clause in sql?

1065

---

Does sql view stored data?

999

---

What is sql and how does it work?

1244

---

What is left join example?

1002

---

How many triggers can be applied to a table?

1120

---

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

1639

---

What are sql*plus environment variables?

1145

---

What is the difference between distinct and unique in sql?

988

---

What is a null value?

1185

---

How many functions are there in sql?

1091

---