how to get count of tables in particular database in Oracle?

Answers were Sorted based on User's Feedback



how to get count of tables in particular database in Oracle?..

Answer / nirav21686

Select Count(*) From User_Tables

Is This Answer Correct ?    16 Yes 0 No

how to get count of tables in particular database in Oracle?..

Answer / ajitnayak

SELECT COUNT(DISTINCT TABLE_NAME)
FROM COLS

Is This Answer Correct ?    0 Yes 0 No

how to get count of tables in particular database in Oracle?..

Answer / abc

select count(*) from tab;

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More Oracle General Interview Questions

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  


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)