how to get count of tables in particular database in Oracle?
- 3 Answers
- 5050 Views
- I also Faced
- E-Mail Answers
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 list all user accounts in oracle?
how to make an oracle object
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What is the usage of control file in oracle?
How to delete a column in an existing table in oracle?
Explain the types of exception?
How do we display rows from the table without duplicates?
Is rowid unique in oracle?
Can you tell me how to add new column in existing views?how?How is possible?
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 to retrieve data from an explicit cursor?
What is a cognitive schema?
What happens in oracle commit?
What are set operators?
List the parts of a database trigger.
