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 is a data definition language?

1094

---

What is query syntax?

958

---

Is sql considered coding?

1039

---

What is a sql driver?

993

---

How many tables can you join in sql?

952

---

What is join view in sql?

941

---

Explain the select statement in sql?

1103

---

What are the uses of sysdate and user keywords?

1095

---

What are the most important ddl statements in sql?

1100

---

What is a dynamic query?

1016

---

1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...

2425

---

What is mdf ldf and ndf?

990

---

Which join is like inner join?

1015

---

What is primary key sql?

1025

---

What are the built in functions of sql?

1024

---