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)
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between inner join and left join?
What does the file extension accdb stand for?
what is online transaction processing (oltp)? : Sql dba
tell me about various levels of constraint. : Sql dba
What are the different types of joins in sql?
What is database white box testing and black box testing?
Which type of cursor is used to execute the dml statement?
What has stored procedures in sql?
Write a sql query to get the third highest salary of an employee from employee_table?
How many unique keys can a table have?
What is spool?
What is query execution plan in sql?
What is scalar function?
what is single byte over head in oracle..?
What are the built in functions of sql?