Answer Posted / pravin

Union combines the two table records, its eliminates
the duplicate records. while minus shows only those rows
which are not dulicated of table first in query.

Is sql low level language?

975

---

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...

2391

---

what is the syntax used for partition in tsql? : Transact sql

976

---

Why is pl sql used?

953

---

How is a process of pl/sql compiled?

1106

---

What is rank function in sql?

980

---

Is foreign key mandatory?

962

---

What are pl/sql packages?

1058

---

how to create a new view in mysql? : Sql dba

907

---

How can we make an if statement within a select statement?

974

---

What is the requirement of self-join?

1050

---

How to move files from one directory to another in pl sql?

1148

---

Which data type is a composite type?

945

---

how to concatenate two character strings? : Sql dba

1050

---

Is truncate ddl or dml?

953

---