pl/SQL developer to a query language sentence in multiple different IP network database table data
Now I have the network computer IP database user name and password, how can I query an IP network computer storage directly by statement to a database a table of a field in the value?
Such as now I have 10.10.0.1 computer above a database user name is: user1 password is: password1 instance name former table space name tablespace1 table name table1 field CN1 value value1
And 10.10.0.2 computer has a database user name is: user2 password is: password2 instance name former table space name in tablespace table table2 field CN2 value value2
I now computer
Now I want to the results of a query is
The PC value
PC1 sum (value1)
PC2 sum (value2)


Is unable to realize, must through the different PC landing interface, query again?

CodePudding user response:

Didn't understand, two database query results should be displayed at the same time? How is it possible? Unless on a library by dblink connected to all other databases,

CodePudding user response:

Or query can also step by step, just don't want to by landing interface different database
Want to link directly through statements different database query,

CodePudding user response:

reference 1st floor minsic78 response:

didn't understand, two database query results should be displayed at the same time? How is it possible? Unless on a library by dblink connected to all other databases,

Or query can also step by step, just don't want to by landing interface different database
Want to link directly through statements different database query,

CodePudding user response:

reference weixin_40097177 reply: 3/f

Quote: refer to 1st floor minsic78 response:

Didn't understand, two database query results should be displayed at the same time? How is it possible? Unless on a library by dblink connected to all other databases,

Or query can also step by step, just don't want to by landing interface different database
Want to link directly through statements different database query,

Even so, PLSQL is impossible,
Main such demand just daily routine manual check? Instead of the operation of application system needs to be done? If it is a routine check, can write a shell script to complete,

CodePudding user response:

By creating dblink to connect to the query,