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'

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

0 Answers  

---

What is the difference between SQL and SQL Server?

2 Answers   CTS, TCS,

---

26. Display the earliest shipping date in the format: DD/MON/YYYY

5 Answers   Wipro,

---

Can multiple columns be used in group by in oracle?

0 Answers  

---

How to add another datafile to a tablespace?

0 Answers  

---

How to rename an existing table?

0 Answers  

---

What is use of oracle?

2 Answers   Satyam,

---

What is format trigger?

0 Answers  

---

How to define default values for formal parameters?

0 Answers  

---

What is oracle database 10g express edition?

0 Answers  

---

two tables are there emp(eno,ename,sal,deptno),dept(deptno,dname).how form the query in deptno,ename,max(sal)

2 Answers  

---

What is the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN?

1 Answers  

---