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
- 9619 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 run pl sql program in mysql?
Does view store data in sql?
What is varray in pl sql?
Can a commit statement be executed as part of a trigger?
What is the difference between delete, truncate and drop command?
What is data types in sql?
What are all different types of collation sensitivity?
Why do we use sql constraints?
What is sql scripting?
How can we avoid duplicating records in a query?
What does (+) mean in sql joins?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
What is sqlcontext?
What is the purpose of the primary key?
How do I find duplicates in sql?
