Why we choose emp number as primarykey?

4 Answers  

---

how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as only NN,but not other alphabets, if NN is thre means i should display , otherwise leave that blank or empty Its some urgent requirement ,thanks in advance

2 Answers  

---

waht is referencial integrity?

2 Answers   Semantic Space,

---

after installatio of ORACLE 8i, work properly, but after restarting the system, it throw an error ORA 01034: ORACLE not availble

1 Answers  

---

Can sub procedure/function be called recursively?

0 Answers  

---

Please explain drop constraint oracle?

0 Answers  

---

What are Schema Objects ?

2 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,

---

what diffrence between function and procedure?

4 Answers  

---

How to apply filtering criteria at group level in oracle?

0 Answers  

---

What are the sql clauses supported in the link property sheet ?

1 Answers   Oracle,

---

What is an Oracle index?

0 Answers  

---