How many rows will return from dual table?

4 Answers   Fujitsu,

---

Hi all, i have a table as follows empid empname mgrid deptid 1 a 3 4 2 b 1 5 3 c 2 3 4 d 3 6 5 e 4 7 i want the output as empname mgrname a c b a c b d c e d

4 Answers  

---

What are the different types of constraints?

0 Answers  

---

Can a view be mutating? If yes, then how?

0 Answers  

---

Does execute immediate commit?

0 Answers  

---

What is duration in sql profiler trace?

0 Answers  

---

There is a sequence with min value 100. I want to alter this sequence to min value as 101. If the table has already data in the sequence column as 100,101,102... Is it possible to do so ?

4 Answers   IBM,

---

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

0 Answers  

---

how can i read write files from pl/sql

3 Answers  

---

how to get a list of indexes of an existing table? : Sql dba

0 Answers  

---

Is null operator in sql?

0 Answers  

---

why sql is used as interpreter frequently rather than a compile?

1 Answers  

---