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)
Answers were Sorted based on User's Feedback
Answer / neeraj sinha
suppose you have two databases: db1 and db2
you have to select one of them
as
sql>use db1;
then use
sql>select * from tab;
it will show you the listing required.!
Is This Answer Correct ? | 11 Yes | 2 No |
Answer / amit
Suppose your 2 databases are name as PROD1 and PROD2
1) How can create a table in particular database?
=> First you have to connect to the database where you want
to create table with given login and password.
and then if you have create permission than you can use
following sql
CREATE TABLE "table_name"
("column 1" "data_type_for_column_1",
"column 2" "data_type_for_column_2",
... )
2) select * from tab; will show you how many tables,view or
synonyms are there in your schema.
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / meher
If you want to list the tables presented in each database
use the below query:
SELECT * FROM DBA_TABLES; or SELECT * FROM USER_TABLES; -->
this will display all the tables of particulara db.
If you use SELECT * FROM TAB; --> this will display all the
tables,views or synonyms of particulara db.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / vishnu
you can also use the database links to get the data from
other database tables. syntax is table_name@db_link.
Is This Answer Correct ? | 3 Yes | 2 No |
Answer / 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 |
List out the acid properties and explain?
how is exception handling handled in mysql? : Sql dba
How do you write a complex sql query?
What is oracle ? why we should go for oracle database instead of diffrent databases available in the industry.
how would concatenate strings in mysql? : Sql dba
SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual;
Is sql an operating system?
How do you delete a table?
Can %notfound return null after a fetch?
How to Execute a Package in PL/SQL.?
What is difference between cursor and ref cursor?
what is organisational index?