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
- 9756 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 to use case expression? : Sql dba
What is the command used to fetch first 5 characters of the string?
differentiate between float and double. : Sql dba
what is column? : Sql dba
What is pl sql collection?
Why is pl sql needed?
Does sql support programming?
Which nosql database is best?
What is sql in oracle?
What is difference between left and right outer join?
How do you update a sql procedure?
When sql appeared?
Differentiate between sga and pga.
How many types of tables are there?
what is text? : Sql dba
