When we give SELECT * FROM EMP; How does oracle respond?

24 Answers   Accenture, HCL, Infosys,

---

How do I copy a table in sql?

0 Answers  

---

Explain the difference between 'between' & 'and' operators in sql

0 Answers  

---

What is an Integrity Constraint?

4 Answers  

---

if a table is getting updated what happens if a function is called from sql query?

2 Answers   RBS,

---

What are the types of index in sql?

0 Answers  

---

What is trigger in pl sql?

0 Answers  

---

what eliminate duplicate without using roenum and not

5 Answers   Matrix,

---

i have a table emp and columns ename,empno,mgr_id,i need ename,manager name as result i.e employee respective manager.. example empno ename mgr_id 1 john 3 2 paul 3 3 smith 1 4 kevin 1 5 stewart 2 result has to look like this ename manager john smith paul smith smith john kevin john stewart paul can u plz help me out in this.....

8 Answers  

---

If the base table structure is changed what will happen to join index????

2 Answers  

---

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

0 Answers  

---

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

0 Answers  

---