what is the use of rank function?

1 Answers  

---

emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example

1 Answers  

---

How to create a stored procedure in oracle?

0 Answers  

---

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

0 Answers   MCN Solutions,

---

you are sorting a table using "order by"(descending) clause of a column which contains a null value...whether that row containing null value will come first or last in the output??

2 Answers   BirlaSoft,

---

what is the difference between primary key & foreign key?

57 Answers   CTS, Infosys, La Multi, Sparsh, Wipro,

---

What are the benefits of ordbms?

0 Answers  

---

What is java oracle used for?

0 Answers  

---

5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.

3 Answers   Wipro,

---

how to truncate date and get only time part 9:20:00

5 Answers  

---

How to use "startup" command to start default instance?

0 Answers  

---

Explain the use of rows option in imp command.

0 Answers  

---