Answer / nirav21686

Select Count(*) From User_Tables

Answer / ajitnayak

SELECT COUNT(DISTINCT TABLE_NAME)
FROM COLS

Answer / abc

select count(*) from tab;

what happened to the global index when I truncate the data in one of the partition?

0 Answers  

---

what is the use of rank function?

1 Answers  

---

How to define a variable to match a table column data type?

0 Answers  

---

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

0 Answers   Microsoft,

---

Explain the features of oracle?

0 Answers  

---

interview questions with answer for cts

0 Answers   Cognizant,

---

What are the attributes that are found in a cursor?

0 Answers  

---

how to use sequence and what use of sequence cache

1 Answers  

---

What is a procedure in oracle?

0 Answers  

---

The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ================ 1 NULL 2 NULL 3 4 NULL 5 6 7 NULL NULL O/P C = 2 4 6

2 Answers   TCS,

---

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

0 Answers  

---

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

1 Answers  

---