Answer / nirav21686

Select Count(*) From User_Tables

Answer / ajitnayak

SELECT COUNT(DISTINCT TABLE_NAME)
FROM COLS

Answer / abc

select count(*) from tab;

23. Display the client name for all clients who have placed an order where any order line has more than 3 items. Do not use a table join anywhere in your query.

3 Answers   Wipro,

---

what is the use of system.effective.date variable in oracle?

0 Answers  

---

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

0 Answers  

---

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

0 Answers   Sierra Atlantica,

---

How to add a new column to an existing table with a default value?

0 Answers  

---

---

How to define default values for formal parameters?

0 Answers  

---

What is using clause and give example?

0 Answers  

---

How to increment dates by 1 in oracle?

0 Answers  

---

A USER HAVING CREATE SESSION PREVILAGE CAN ALTER PASSWORD/CHANGE PASSWORD?

2 Answers  

---

what is load balancing and what u have used to do this?(sql loader)

3 Answers  

---

Explain what are the type of synonyms?

0 Answers  

---

What are the differences between number and binary_float in oracle?

0 Answers  

---