how to get count of tables in particular database in Oracle?
Answer Posted / ajitnayak
SELECT COUNT(DISTINCT TABLE_NAME)
FROM COLS
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to speed up webrick?
Difference between cartesian join and cross join?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
What is not equal to in oracle?
How to display employee records who gets more salary than the average salary in the department?
What is a view and how is it different from a table?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
How does Oracle guarantee data integrity of data changes?
What are the restrictions in a oracle read only transaction?
What are the limitations of check constraint?
defination of bitmap index
How can you use check constraints for self referential integrity?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
How to sort output in descending order in oracle?
Explain the use of parfile option in exp command.