RE: SQL Text

From: Paul van Dijken <paul.vandijken_at_sema.nl>
Date: Fri, 29 Sep 2000 12:27:39 +0200
Message-Id: <10634.118210@fatcity.com>

Why would you want to use a dot in an alias ? I can see why you need the dot in the original name ("Select a.col_1, b.col_2 from AA a, BB b;")

Paul

-----Original Message-----
From: Nosie [mailto:tekait11_at_bni.co.id]
Sent: 29 September 2000 08:15
To: Oracle Mailinglist; Oracle Lazy DBA; Oracle fatcity Subject: SQL Text

Dear All,

I develop VB6 application with Oracle8i and ADO connection. The SQL text need to use dot puntuation for column name alias, such as in: "SELECT col_1 F.NAME, col_2 L.NAME, col_3 ADDRESS FROM table_1"

Such text produce an error message "missing FROM keyword" of VB or ODBC(?).

How and why ??? from Oracle database viewpoint????

Thanks a lot in advance

Sincerely,

Nosie
< tekait11_at_bni.co.id >

---

If you're bored, then visit the list's website: http://www.lazydba.com (updated daily)
to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk Received on Fri Sep 29 2000 - 05:27:39 CDT