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

How to loop through data rows in the implicit cursor?

0 Answers  


How to use group functions in the select clause using oracle?

0 Answers  


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 the truncate in oracle?

0 Answers  


What is the difference between column level constraints and table level constraints?

14 Answers   IBM, TCS,


How to divide query output into groups in oracle?

0 Answers  


What is Rollback Segment ?

3 Answers  


What language does oracle use?

0 Answers  


what are the disadvantages of hierarchial database over RDBMS?

1 Answers   TCS,


hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.

0 Answers  


How are Indexes Update ?

1 Answers  


What is oracle and what are its different editions?

0 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)