Part of this sql is to get data from a table on a different oracle server named wicked:
left outer join (select a.* FROM ibdd_caspr.ts_new_loan_prod_fact@wicked a
The error that I get is invalid username/password.
How do I login to the Wicked server in order to use this dblink?
The full sql is attached.
test sql for Toad.sql (2.89 KB)