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
- 9610 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
What is the purpose of primary key?
What does sign mean sql?
what are the authentication modes in sql server? How can it be changed? : Sql dba
What is the use of nvl function?
Does sqlite need a server?
What is union and union all keyword in sql and what are their differences?
How do I count records in sql?
What is embedded sql what are its advantages?
What are the benefits of triggers?
How can you load multi line records? : aql loader
How do you delete data from a table?
what is acid property in database? : Sql dba
What does an inner join do?
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc
Can we use two order by clause in query?
