What is the difference between postgresql and oracle?

0 Answers  

---

How to load data from external tables to regular tables?

0 Answers  

---

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

0 Answers   EDC,

---

how to produce numbers from 1 to 10 using dual table

4 Answers   Genpact,

---

select * from emp what happened internally when we write this query in the sql prompt?

5 Answers  

---

---

Query to retrieve record for a many to many relationship ?

0 Answers   Keane India Ltd,

---

SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)?

1 Answers   ESS,

---

What is recycle bin in Oracle?

0 Answers   MCN Solutions,

---

What is null value in oracle?

0 Answers  

---

I have one table :EID,Depid,ename,sal I want to have max(sal) in each department.

5 Answers   Microsoft, Oracle, TCS,

---

What is the difference between PFILE and SPFILE in Oracle?

0 Answers   MCN Solutions,

---

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  

---