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
- 9360 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 use of triggers?
what does the t-sql command ident_incr does? : Transact sql
How do I upgrade sql?
How do I run a sql query in pgadmin 4?
How do you know if a relationship is 2nf?
What is cte?
What do you understand by pl/sql packages?
When can we use the where clause and the having clause?
How we can update the view?
Can we perform dml in function?
What is union and union all keyword in sql?
difference between anonymous blocks and sub-programs.
What are sql built in functions?
Can we commit inside a trigger?
When is the explicit cursor used ?
