dblink

相关标签：javascript jquery android 多少钱 iPhone

How can I get the column names of a table referred by a dblink?

I am new to oracle. I have a table referred using a dblink, say MY_TABLE@MY_DBLINK. Suppose MY_TABLE has columns like COLUMN_1, COLUMN_2. How can I write a query to return the column names?[详细]

2023-04-12 04:58 分类：问答
Keeping track of all values created by a sequence for multiple inserts

In PL SQL, I\'m writing a stored procedure that uses a DB link: CREATE OR REPLACE PROCEDURE Order_Migration(us_id IN NUMBER, date_id in DATE)[详细]

2023-03-28 05:03 分类：问答
How to make ActiveRecord access a table from a dblink (correctly)?

I am developing a RoR project using an Oracle database. Recently I added a DBLink to another database and this works perfectly just from an SQL.[详细]

2023-03-27 06:30 分类：问答
Add Indexes to columns in remote table - Oracle

Am querying a remote database using DBLink. Now am wondering to speed up the query, how can i add indexes to few columns in the remote table.[详细]

2023-03-23 22:26 分类：问答
Moving XML over a DBLink

I am trying to move some data over a dblink and one of the columns is an XMLType column. The code looks like this:[详细]

2023-03-10 20:39 分类：问答
postgresql: INSERT INTO ... (SELECT * ...)

I\'m not sure if its standard SQL: INSERT INTO tblA (SELECT id, time FROM tblB WHERE time > 1000)[详细]

2023-03-07 08:20 分类：问答
select * through dblink

I have some trouble when trying to update a table by looping cursor which select from source table through dblink.[详细]

2023-03-06 06:40 分类：问答
insert blob via odp.net through dblink size limitations

i am using ODP.NET (version 2.111.7.0) and C#, OracleCommand & OracleParameter objects and OracleCommand.ExecuteNonQuery method[详细]

2023-02-25 18:36 分类：问答
Loading dblink.sql in Postgres 8.4

I found good article in dblink http://www.postgresonline.com/journal/archives/44-Using-DbLink-to-access-other-PostgreSQL-Databases-and-Servers.html, but got stuck on loading dblink.sql.[详细]

2023-02-25 12:36 分类：问答
Using Partition on oracle table from a DB link

I am working on Oracle 9i my question is: can I use a partition over a table through a dblink for example I am working on DB1 and want to use a table A_table which has a partition with name part1 f[详细]

2023-02-23 06:33 分类：问答