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'

i have a table with 1 lac of data.i want to insert this data into another table. i want every 5000 of data insert use a commit.using counter and if error is comming in the 5000 of data it rollback.

1 Answers   MasterCard,

---

Explain what are the type of synonyms?

0 Answers  

---

What is PL/SQL ?

0 Answers  

---

Will you be able to store pictures in the database?explain.

0 Answers  

---

How to find the duplicate rows count from employees table in oracle?

0 Answers  

---

---

how can we store any pdf file in oracle

0 Answers  

---

In oracle there is column command, how will you explain that?

0 Answers   Aricent,

---

How to Truncate Table in Oracle

0 Answers   HCL,

---

What is the difference between "as" and "is" in an oracle stored procedure?

0 Answers  

---

How do we get field detail of a table?

0 Answers  

---

Is primary key = unique key,not null? If yes,please explain IF No,please explain

8 Answers   Genpact,

---

How to estimate disk space needed for an export job?

0 Answers  

---