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
- 8649 Views
- Relq, I also Faced
- E-Mail Answers
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
how to start mysql server? : Sql dba
What is the difference between null value, zero, and blank space?
What does (*) mean in sql?
What are the packages in pl sql?
What are predefined functions in sql?
what is a database lock ? : Sql dba
What is a variable in sql?
What is difference between hql and sql?
What is sqlerrm?
what is a unique key ? : Sql dba
what are the different type of normalization? : Sql dba
What is sql not null constraint?
What is package in pl sql with an examples?
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
What is int identity in sql?
