Article View: chile.comp.programacion
Article #3528Re: Consulta SQL Oracle...
From: Chano Records Inc.
Date: Fri, 11 Feb 2005 19:21
Date: Fri, 11 Feb 2005 19:21
17 lines
1673 bytes
1673 bytes
Chano Records Inc. wrote: > Tengo una consulta > > SELECT COLA_TA, COLB_TA, COLA_TB, COLA_TC > FROM TABLA_A, TABLA_B, TABLA_C > WHERE (condiciones varias) > AND COLX_TB = COLX_TC(+) > > Que significa el (+) al final de la ultima condicion? Ya lo encontr๏ฟฝ :) The optional "(+)" lets you specify that table_collection_expression should return a row with all fields set to NULL if the collection is null or empty. The "(+)" is valid only if collection_expression uses left correlation. The result is similar to that of an outer join. For more information see "Outer Joins".
Technical Details
Message-ID:
<cuj0j9$6v6$2@localhost.localdomain>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!news.kjsl.com!news1.nivel5.cl!news.cec.uchile.cl!not-for-mailReferences:
<cuj0fu$6v6$1@localhost.localdomain>Show Full Headers
Complete Article Headers
X-Google-Thread: 1593cb,560a7576f5e69945,start X-Google-Attributes: gid1593cb,public X-Google-Language: ENGLISH,ASCII Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!news.kjsl.com!news1.nivel5.cl!news.cec.uchile.cl!not-for-mail From: "Chano Records Inc." <chano@lj.nospam.cl> Newsgroups: chile.comp.programacion Subject: Re: Consulta SQL Oracle... Date: Fri, 11 Feb 2005 16:21:35 -0300 Organization: Centro de Computacion - U. de Chile Lines: 18 Message-ID: <cuj0j9$6v6$2@localhost.localdomain> References: <cuj0fu$6v6$1@localhost.localdomain> NNTP-Posting-Host: vpn-client-025.cec.uchile.cl Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Trace: localhost.localdomain 1108149673 7142 172.17.35.25 (11 Feb 2005 19:21:13 GMT) X-Complaints-To: news@localhost.localdomain NNTP-Posting-Date: Fri, 11 Feb 2005 19:21:13 +0000 (UTC) User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en In-Reply-To: <cuj0fu$6v6$1@localhost.localdomain>