ANSI SQL

From: Daniel CW2 CTARNG Maldonado (daniel.maldonado_at_CT.NGB.ARMY.MIL)
Date: 01/18/05 

To: dbi-users@perl.org
Date: Tue, 18 Jan 2005 15:37:40 -0500

OK, I am facing a bit of a dilema here.

I am trying to help a group of developers convert a blog system to Oracle.

This system was originally written for Mysql but would be great if we could
get it working with other DBMS.

I am not sure how to make Oracle understand aliases such as:

   "select field1 as field1_alias from table1"

as far as I know this would have to be written:

   "select field1 field1_alias from table1"

to work under Oracle.

 

I was thinking of writing a pre_parse() function that would parse the sql
syntax before handing it over to DBI but that seems pretty extreme.

 

Is there an easier way???

 

Daniel Maldonado

Programmer Analyst

Relevant Pages

  • RE: ANSI SQL
    ... It would be exactly the same in Oracle. ... Subject: ANSI SQL ... I am facing a bit of a dilema here. ... I am trying to help a group of developers convert a blog system ...
    (perl.dbi.users)
  • Re: [ANN] Oracle JDeveloper 10g production is now available for download.
    ... >> developers to join the Java camp. ... >> services, JavaBeans, Toplink and Oracle ADF Business components) ... >> you easily bind EJB, Web services, Javabeans, TopLink, or ADF Business ... Can you specify where in eclipse do you get any of the following? ...
    (comp.lang.java.softwaretools)
  • Re: Need help with tools
    ... developing and supporting databases. ... I would suggest not touching any part of Oracle until you understand ... Application Developers Guide - Fundamentals instead of Concepts, ...
    (comp.databases.oracle.server)
  • Re: [ANN] Oracle JDeveloper 10g production is now available for download.
    ... > developers to join the Java camp. ... However, experienced developers will ... > services, JavaBeans, Toplink and Oracle ADF Business components) ... > objects, and Web services. ...
    (comp.lang.java.softwaretools)
  • Re: How to Create Local Temporary Table
    ... application developers don't know squat about SQL and run scared of a three way join, never mind what Oracle calls an inline view. ... How Oracle implements temp tables is not the same, as such the developer utilizing temp tables in Oracle needs to know this and should consider other alternatives. ... It's not a Sybase/SQL Server feature as such. ...
    (comp.databases.oracle.server)