dblink
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 分类：问答
![Interactive visualization of a graph in python [closed]](https://www.devze.com/res/2023/04-10/09/92d32fe8c0d22fb96bd6f6e8b7d1f457.gif)
加载中,请稍侯......