File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Soft Skills: The software developer's life manual this week in the Jobs Discussion forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SQL Query

 
Premila Devi Dayalan
Ranch Hand
Posts: 40
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Sheriff
Pie
Posts: 47216
52
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
author & internet detective
Marshal
Posts: 33667
316
Eclipse IDE Java VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 40
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dear Sir,

Please advise me,on these.



Example:
The Schema is, , 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.


     
    • Post Reply
    • Bookmark Topic Watch Topic
    • New Topic