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
- 9601 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 are dml commands?
Is primary key always clustered index?
What is the difference between numeric and autonumber?
Do we need commit after truncate?
What is meant by temporal data?
what is transaction? : Sql dba
Is oracle and sql same?
What is scope and visibility in PL/SQL?
What are literals in sql server?
What is use of trigger?
How to pipe multiline string to isql?
How can use stored procedures in sql?
What is the use of function in sql?
Can we use insert statement in function?
Which tcp/ip port does sql server run?
