dblink
Run SQL Server Stored Procedure via Database Link from Oracle
Referring to How to execute an Oracle stored procedure via a database link, it does not work in my case. I don\'t know what I am missing.[详细]
2023-02-22 07:52 分类:问答Installing DBLink for Postgres 9
Can someone please shed some light on how to install the requirements for Postgres 9 (Centos) to be able to use dblink for inter-postgres db querying.[详细]
2023-02-12 19:03 分类:问答SQL Server nested cursor problem
I have a strange problem with my nested cursors and I have no idea what it\'s all about. Here\'s my T-SQL code:[详细]
2023-01-29 05:32 分类:问答How to use (install) dblink in PostgreSQL?
I am used to Oracle and to create a dblink in my schema and then access to a remote database like this: mytable@myremotedb, is there anyway do to the same wi开发者_如何学Pythonth PostgreSQL?[详细]
2023-01-19 05:13 分类:问答Postgres, plpgsql: Is there a way to connect to other DB from inside of a stored procedure?
I have two DB\'s one is f开发者_运维知识库eed by filtered data from another, now i\'m using perl script witch executes query on foreign DB, stores a result in a csv file, and loads it to local DB usin[详细]
2023-01-12 14:05 分类:问答Why does DbMetal Generate Table Attribute with "main"?
I\'m a newbie with DBLink and Sqlite. When DbMetal generates Nortwind.cs (C#) it marks some methods with a Table attribute:[详细]
2023-01-10 18:32 分类:问答Oracle clob over dblink with different charset
Here is the scenario: Oracle A: charset WE8ISO8859P1 Oracle B: charset WE8MSWIN1252 Oracle A <- dblink -> Oracle B[详细]
2023-01-10 14:38 分类:问答Oracle stored procedure DB Link question
I have a stored procedure FOO belonging to user A.User B has EXECUTE permission on FOO. One of the procedures in FOO uses a DB Link to retrieve data from BARTABLE@REMOTEDB.A has a DB Link to REMOTEDB[详细]
2023-01-05 02:59 分类:问答Select and Insert across dblink
I am having a bit of trouble with a select into insert across a dblink in oracle 10.I am using the following statement:[详细]
2022-12-23 09:44 分类:问答How to connect to two databases of Oracle using dblink
I am tring to use db link for that I have first change the name of both databases to sol1(remote) and sol3(local) then I create a db link[详细]
2022-12-22 03:14 分类:问答