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
- 8655 Views
- Relq, I also Faced
- E-Mail Answers
Answer Posted / priya
login to one database like
sqlplus username@databasename/password
After enter into sql
create table databasename.tablename
and to call select * from databasename.tablename
then to connect to other user
connect dbuser/pwd (not sure of this statement .. It should
be something like this please google it otherwise)
and to list the tables particular to database:
select * from tab; fetch the result from that particular
database which is connected
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do I get sql certification?
How do I make my sql query run faster?
What are pl/sql cursors?
Why is pl sql needed?
what are the differences between binary and varbinary? : Sql dba
What is a variable in sql?
What is mdb stand for?
What is pl sql and why it is used for?
How sql query is executed?
Why select is used in sql?
differentiate between float and double. : Sql dba
What is sqlcontext?
How to get list of all tables from a database?
What is execute immediate?
When to use inner join and left join?
