Answer / mani

Select max(rownum) from table_name;

Answer / anil kumar

select sum(1) from table_name;

Answer / rajender varma

Select num-rows from user-tables where table-name='emp'

What is the effect of setting the value of OPTIMIZER_MODE to 'RULE' ?

1 Answers  

---

What privilege is needed for a user to query tables in another schema?

0 Answers  

---

Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?

6 Answers   IBM,

---

What are the attributes of the cursor?

0 Answers  

---

How do I use os authentication with weblogic jdriver for oracle and connection pools?

0 Answers  

---

Why do we use bulk collect in oracle?

0 Answers  

---

19. Display all clients whose name begins with the letter J or contains the letter M anywhere or contains E as the third letter.

2 Answers   Wipro,

---

How to loop through a cursor variable?

0 Answers  

---

What are the execution control statements?

0 Answers  

---

Hi, I want table structure shown below. How can i create this ? Num Name Address Addr1 Addr2 I want Addr1 and Addr2 under Address column. How can i achive this ? Is it possible ?

2 Answers   IBM,

---

What is the difference between an Oracle Schema and an Oracle Instance?

3 Answers   IBM,

---

How to increment dates by 1 in oracle?

0 Answers  

---