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
- 9554 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
Where the sql database files are stored?
What is the file extension for sql database?
How do I add a database to sql?
What is minus?
explain the options of myisamchk to improve the performance of a table. : Sql dba
what are the types of join and explain each? : Sql dba
What is sql clause?
What do you understand by pl/sql packages?
Why do we use partitions in sql?
What is full join?
Why do we need sharding?
What is execution plan in sql?
How do I count duplicates in sql?
what is column? : Sql dba
What is a database trigger?
