Answer / pavani

No, we can't use more than one null value for unique key.
Unique means it doesn't accept duplicate values.

Does sql require a server?

0 Answers  

---

Is grant a ddl statement?

0 Answers  

---

How do you break a loop in pl sql?

0 Answers  

---

Why are aggregate functions called so?

0 Answers  

---

What is TABLE SPACE?

4 Answers   ABB, TCS,

---

What is the syntax and use of the coalesce function?

0 Answers  

---

Is oracel sql developer written in java?

0 Answers  

---

While inserting 10 rows using procedure, if 3rd entry is having some error, what will be the output? How u will handle that error?

8 Answers   iFlex,

---

what are the different types of joins?

4 Answers   Choice Solutions,

---

How to get employee name from employee table which is the fiveth highest salary of the table

20 Answers   Infosys, Rolta,

---

type type_name is table of varchar2(30) index by binary_integer for the above type you have to create a identifier... like identifier_name type_name; for the above type you can use the below methods..like first , last , prior, next , delege..etc...like this.. if you create a cursor...like cursor cursor_name is select * from scott.emp; is there any methods like above to use prior, fist , last , next , trim ,etc...

1 Answers   Satyam,

---

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

0 Answers   Satyam,

---