I have an SQL script that connects to another database using \"create database link\", and copies some data.
Is it possible to have dynamic database links in Oracle? I am using Oracle9i database. Let me illustrate by what I require.
I\'m completely baffled by the results of this query: select count(*) from my_tab mt wheremt.stat = \'2473\'
I have a need to create a database link that is a link to a schema o开发者_JAVA技巧n the same server. Is there a special keyword to use for this? ( like local or localhost )
I am working on a site similar to Craigslist where users can make postings and sell items in different cities. One difference between my site and Craigslist will be you will be able to search by zip c
The environment is Oracle 9 & 10.I do not have DBA level access. The problem is to verify that a specific column exists in a specific table, in another schema.