Interested to Buy Any Domain ? << Click Here >> for more details...
I have 2 Databases. How can create a table in particular
database? How can i know the list of tables presented each
database?( in oracle 10g)
- 5 Answers
- 9349 Views
- Relq, I also Faced
- E-Mail Answers
Answer Posted / meher
If you want to list the tables presented in each database
use the below query:
SELECT * FROM DBA_TABLES; or SELECT * FROM USER_TABLES; -->
this will display all the tables of particulara db.
If you use SELECT * FROM TAB; --> this will display all the
tables,views or synonyms of particulara db.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Why use subqueries instead of joins?
How do you update a sql procedure?
What is sap sql anywhere?
Differentiate between syntax and runtime errors.
What is PL/SQL Records?
what is datawarehouse? : Sql dba
What are string functions in sql?
Differentiate pl/sql and sql?
How to create a menu in sqlplus or pl/sql?
tell us something about heap tables. : Sql dba
How does index help in query performance?
What are different sql data types?
When is the update_statistics command used?
How do you modify a column in sql?
What is sql prepared statement?
