database-link
Should database base links in oracle be dropped/closed after you are done using them?
I have an SQL script that connects to another database using \"create database link\", and copies some data.[详细]
2023-01-23 23:06 分类:问答Dynamic DB links in Oracle
Is it possible to have dynamic database links in Oracle? I am using Oracle9i database. Let me illustrate by what I require.[详细]
2023-01-16 00:43 分类:问答Oracle EXISTS query is not working as expected - DB Link bug?
I\'m completely baffled by the results of this query: select count(*) from my_tab mt wheremt.stat = \'2473\'[详细]
2023-01-02 02:26 分类:问答How do I create a Database Link where remote and local are the same server
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 )[详细]
2023-01-01 19:24 分类:问答How to design this database layout?
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[详细]
2022-12-30 07:13 分类:问答How does one cheaply validate the existance of a column in a table in another schema with Oracle?
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.[详细]
2022-12-10 07:02 分类:问答