Re: translation needed SYBASE to ORACLE

A copy of this was sent to cloon77_at_my-deja.com (if that email address didn't require changing) On Thu, 27 Jan 2000 14:19:31 GMT, you wrote:

>Hi I need the translation from a statement in SYBASE to return the same
>value in ORACLE.
>
>I've tried every thing that come in mind but I'm still stuck....
>
>
>
>
>Select Properties_Name.Language,Properties.ID,Properties.ObjectID,
>Properties."Key",Properties_Name.Name,Properties.Type,
>Properties."Order",Properties.Attributes,Properties_Name.PropID,
>Properti es.UniqueValue
>From Properties left outer join Properties_Name
>on Properties.ID=Properties_Name.PropID
>AND properties_name.language=1
>Where Properties.ObjectID = 0
>
>

from properties, properties_name
where properties.id = properties_name.propid (+) and properties_name.language (+) = 1
and properties.objectid = 0

will make up a row in PROPERTIES_NAME if none exists.

>
>thanks ...
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Jan 27 2000 - 09:02:25 CST