FW: (+) in DBPROCS

"Nigel Campbell (DSL AK)" <[email protected]>
Newsgroups gmane.comp.db.sapdb.general
Message-ID <[email protected]>
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.