Answer Posted / humayun quaiser

unoin:- This operator returns from all the queries(combined
through union) but not duplicate record will be display.
ex- A={1,2,3,4}
B={2,3,4,5}
AUB={1,2,3,4,5}............

Minus:- This operator displays records which belongs to only
the first query.
ex:- A={1,2,3,4}
B= {2,3,5}
A-B={1,4}...................

what are dynamic queries in t-sql? : Transact sql

1004

---

What are the types of optimization?

932

---

How to start oracle sql developer?

1014

---

what are the advantages a stored procedure? : Sql dba

962

---

When can we use the where clause and the having clause?

1009

---

what is clause? : Sql dba

1052

---

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1568

---

What is a primary key called that is made up of more than one field?

1330

---

what is bcp? When does it used? : Sql dba

974

---

what is a stored procedure? : Sql dba

1108

---

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

2412

---

What is the need of merge statement?

1011

---

What is the current version of postgresql?

1047

---

Can there be more than one function with a similar name in a pl/sql block?

969

---

What is the difference between rename and alias?

1326

---