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 types of indexes in sql?

1082

---

How do I kill a query in postgresql?

1129

---

What are the limitations of sql express?

1071

---

What are the datatypes available in pl/sql ?

1104

---

What is a call statement? Explain with an example.

1010

---

What is a mutating table and a constraining table?

1115

---

What is sql basics?

1043

---

How do I partition a table in sql?

1131

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

960

---

What is a system versioned table?

986

---

What are sql procedures?

1027

---

Which type of cursor is used to execute the dml statement?

957

---

List out the acid properties and explain?

952

---

What is the purpose of cursors in pl/sql?

1136

---

What are user defined functions?

1018

---