SQL Query

[Premila Devi Dayalan]

I could like to write a SQL Query for SELECT data from one Database Table Example :Database Name:db_cam_eve,and table name:cam_asset location and insert the Data Into another Database,Example:Database Name:db_cam_it,with same table name as cam_asset location.

Here I just wanted to gripped the data from other Database[db_cam_eve] and put in another database[db_cam_it],which have same table name.

Is it possible.

Please advise.

[moderator edit: disabled smilies because they interfiered with content]

[Campbell Ritchie]

Please tell us that the thread is about in its title.

Can't you specify the table names with database_name.table_name?

[Jeanne Boyarsky]

Premila,
Different databases or different schemas? If different schemas, you can specify schema_name.table_name. (assuming your user id has access to both schemas of course)

Accessing different databases is more complicated. And database specific. For example, in Oracle you can use a synonym.

[Premila Devi Dayalan]

Dear Sir,

Please advise me,on these.

COLUMN FIRST_NAME HEADING 'First Name' FORMAT A20
COLUMN LAST_NAME HEADING 'Last Name' FORMAT A20
COLUMN PHONE_NUMBER HEADING 'Phone Number' FORMAT A20

SELECT e.first_name, e.last_name, e.phone_number
  FROM hr.employees e, hr.ord o
  WHERE o.order_id    = 2456 AND
        e.employee_id = o.sales_rep_id;

Example:
The Schema is

 e.first_name

,

e.last_name

,

e.phone_number

which representing the "e" as schema_name.table_name.

What is the benefits of Using Schema sir.

I am using Pg Admin II,to run the database,and there is a "Schema" from the Drop Down Menu.The Schema in my database named "db_cam_it" is

"cam","jbpm" and "public".

.What jbpm and public start for sir.

Please advise me sir.