What are the extensions used by oracle reports?

0 Answers  

---

Can you assign multiple query result rows to a variable?

0 Answers  

---

What exactly do quotation marks around the table name do?

0 Answers  

---

what are the different types of cursors? explain?

4 Answers  

---

Can select statements be used on views in oracle?

0 Answers  

---

---

You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.

3 Answers   Amazon, HCL,

---

if you update view? where we store the data?

5 Answers   Cap Gemini,

---

12. Display the client name in upper case only and in lower case only.

1 Answers   Wipro,

---

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

0 Answers  

---

Which is better Oracle or MS SQL? Why?

2 Answers   Bally Technologies,

---

What is meant by an index?

0 Answers  

---

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

0 Answers  

---