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
- 9351 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
What does the sign mean in sql?
Explain the difference between rename and alias?
What is sqlca in powerbuilder?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
How subquery works in sql?
Describe sql comments?
What is consistency?
What are types of exception?
Which data dictionary views have the information on the triggers that are available in the database?
Can we perform dml on view?
What is clustered and nonclustered index in sql?
How to avoid duplicate records in a query?
What is the difference between left outer join and left join?
explain the difference between bool, tinyint and bit. : Sql dba
Explain the commit statement.
