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)
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
What is the difference between sql and t sql?
Is pl sql better than sql?
What are few of the schema objects that are created using PL/SQL?
What is clause in sql?
What are the various restrictions imposed on view in terms of dml?
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
what is try_catch block in procedure
Which is faster joins or subqueries?
what does it mean to have quoted_identifier on? : Sql dba
Mention what problem one might face while writing log information to a data-base table in pl/sql?
What are some predefined exceptions in pl/sql?
what is primary key? : Sql dba
What is recursive join in sql?
What is sql stand for?
What is sql query optimization?