Answer / nivitha

select * from dba_users order by desc;

Answer / srinivas

select * from all_users;

Answer / a.swarna devi

select * from user_tables;

Please explan Why static query is more faster than dynamic query ?

2 Answers  

---

What is an Oracle view?

1 Answers  

---

What are a query and state the different types of queries and their uses?

0 Answers  

---

What is data type in oracle?

0 Answers  

---

Display the order number and the number of months since the order was shipped for all orders that have been shipped in the last year (365 days). (Hint: Unshipped orders will have a null value).

1 Answers  

---

Why do we use coalesce function in oracle?

0 Answers  

---

Briefly explain what is literal? Give an example where it can be used?

0 Answers  

---

Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15

2 Answers  

---

How to get execution path reports on query statements?

0 Answers  

---

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

0 Answers  

---

What is a Shared SQL pool ?

2 Answers  

---

What are joins..how many types of joins are there?

29 Answers   Amdocs, CSC, TCS,

---