• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • Paul Clapham
  • Devaka Cooray
  • Bear Bibeault
Sheriffs:
  • Junilu Lacar
  • Knute Snortum
  • Liutauras Vilda
Saloon Keepers:
  • Ron McLeod
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Piet Souris
Bartenders:
  • salvin francis
  • Carey Brown
  • Frits Walraven

SQL Query

 
Ranch Hand
Posts: 40
  • 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]
 
Marshal
Posts: 68857
275
  • 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?
 
author & internet detective
Posts: 39956
804
Eclipse IDE VI Editor Java
  • 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
  • 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.


     
    Oh sure, it's a tiny ad, but under the right circumstances, it gets bigger.
    Java file APIs (DOC, XLS, PDF, and many more)
    https://products.aspose.com/total/java
      Bookmark Topic Watch Topic
    • New Topic