Wholly Cow! Well, seeing how I have never putzed around in Oracle that would explain my ignorance on the matter. Nevertheless, doesn't hurt to learn alternate ways of doing things.
-----Original Message----- From: Nigel Campbell (DSL AK) [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 5:42 PM To: '[EMAIL PROTECTED]' Subject: FW: (+) in DBPROCS Not so ancient. Oracle only got ANSI join syntax in 9i. ------------------------------------------------------------------------- Thanks, I appreciate it. I am familiar with outer joins but not using the ancient syntax. Thus far I have not come across this syntax in the SQL Ref on sapdb's site so I thought I should ask so I knew what I was looking at. Time to go dig up some ancient sql syntax docs. -----Original Message----- From: Nigel Campbell (DSL AK) [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 5:17 PM To: '[EMAIL PROTECTED]' Subject: FW: (+) in DBPROCS Outer join. The (+) represents the side of a join that is outer joined in old-style (pre SQL-92 IIRC) join syntax. If you're not familiar with outer joins there are plenty of SQL resources on the web that will explain them. Google is your friend. -----Original Message----- From: Kevin Wilson [mailto:[EMAIL PROTECTED] Sent: Thursday, 21 August 2003 8:48 a.m. To: Sapdb General List (E-mail) Subject: (+) in DBPROCS can anyone tell me what exactly the (+) syntax does in a dbproc? thanks, Kevin "Those who would give up essential liberty to purchase a little temporary safety deserve neither liberty nor safety." -Benjamin Franklin, 1759 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
