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
- 9549 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
Is truncate ddl or dml?
What is a table?
Mention what does plv msg allows you to do?
How do I count duplicates in sql?
What is difference between stored procedures and application procedures?
Why stored procedure is better than query?
Are subqueries faster than joins?
What is dbo in sql?
What is the use of sqldataadapter?
How to connect a sql*plus session to an oracle server?
When is a declare statement required?
what is row? : Sql dba
what is uncommittable transactions? : Transact sql
What is cte?
what is the command line end user interface - mysql? : Sql dba
