Hi Folks … I have a scenario where one of the database is moved from ORACLE DB
to SQL SERVER DB.
There are many sql scripts where (+) is used for outer joins.
My concern is does SQL SERVER understand (+) the same way as ORACLE dose.
Will I have to rewite all my scripts ?
If NO then dose TOAD have any tool/option where by these codes are run as is i.e
with (+) symbal and it runs fine against SQL SERVER database ?
Most probably by internally converting those codes in ANSI SQL format i.e. LEFT
/RIGHT/FULL outer join.