Answer / nirav21686

Select Count(*) From User_Tables

Answer / ajitnayak

SELECT COUNT(DISTINCT TABLE_NAME)
FROM COLS

Answer / abc

select count(*) from tab;

Explain the use of grant option in exp command.

0 Answers  

---

How to create a server parameter file?

0 Answers  

---

What is proxy method?

0 Answers  

---

difference between procedures and function?

7 Answers   IBM,

---

5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.

3 Answers   Wipro,

---

---

Explain joins in oracle?

0 Answers  

---

what is the difference between sql& oracle?

11 Answers   Oracle,

---

Select the Nth lowest value from a table?

4 Answers  

---

Can we insert data in view oracle?

0 Answers  

---

I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.

2 Answers   IBM,

---

query to find the maximum no persons with same age(age colomn) from emp table

1 Answers  

---

How to retrieve data from an explicit cursor?

0 Answers  

---