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?
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)
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.
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.
I am trying to move some data over a dblink and one of the columns is an XMLType column. The code looks like this:
I\'m not sure if its standard SQL: INSERT INTO tblA (SELECT id, time FROM tblB WHERE time > 1000)
I have some trouble when trying to update a table by looping cursor which select from source table through dblink.
i am using ODP.NET (version 2.111.7.0) and C#, OracleCommand & OracleParameter objects and OracleCommand.ExecuteNonQuery method
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.
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
加载中,请稍侯......