Access To Oracle

Article View: bit.listserv.sqlinfo

Article #321

Back to bit.listserv.sqlinfo Previous Next

#321

From: Missy Pont
Date: Tue, 02 Apr 2002 07:23

7 lines
1210 bytes

The statement below is okay with Access but not okay with Oracle.

SELECT (X < Y) AS X_Is_Smaller
FROM MyTable;

Can anyone here able to convert the statement in Oracle? I posted this in
one of the Oracle's groups but haven't gotten any luck. Thanks in advance.

Technical Details

Message-ID: <a8bldr$cnr$1@slb5.atl.mindspring.net>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!feed2.news.rcn.net!rcn!newsfeed1.earthlink.net!newsfeed2.earthlink.net!newsfeed.earthlink.net!newsfeed0.news.atl.earthlink.net!news.atl.earthlink.net!news.mindspring.net!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 11355a,af48d263424a837f,start
X-Google-Attributes: gid11355a,public
X-Google-ArrivalTime: 2002-04-01 23:06:31 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!feed2.news.rcn.net!rcn!newsfeed1.earthlink.net!newsfeed2.earthlink.net!newsfeed.earthlink.net!newsfeed0.news.atl.earthlink.net!news.atl.earthlink.net!news.mindspring.net!not-for-mail
From: "Missy Pont" <missyp@excite.com>
Newsgroups: bit.listserv.sqlinfo
Subject: Access To Oracle
Date: Tue, 2 Apr 2002 02:23:05 -0500
Organization: MindSpring Enterprises
Lines: 9
Message-ID: <a8bldr$cnr$1@slb5.atl.mindspring.net>
NNTP-Posting-Host: 9e.fc.16.69
X-Server-Date: 2 Apr 2002 07:08:43 GMT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000