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
- 9354 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
What is a sql instance vs database?
Can we delete column in sql?
explain the difference between delete , truncate and drop commands? : Sql dba
What do you mean by query optimization?
Why are cursors used?
What is scalar and vector?
Define SQL and state the differences between SQL and other conventional programming Languages?
When do we use triggers?
What is the most restrictive isolation level? : Transact sql
Define commit?
what are the different type of normalization? : Sql dba
What is denormalization in a database?
What is restrict in sql?
How to test for null values?
Is record in oracle pl sql?
