Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to convert MSACCESS Query to ORACLE SQL

Re: How to convert MSACCESS Query to ORACLE SQL

From: Jose Francisco Gomez Diez <jfgomez_at_fimestic.es>
Date: Wed, 23 Sep 1998 16:21:06 +0200
Message-ID: <6ub03q$rck$1@talia.mad.ibernet.es>


Hi!

Run this query:

  select col1, col2, col3
  from my_table
  where rownum < 16;

Regards,
Jose.

                     Jose Francisco Gomez Diez <jfgomez_at_fimestic.es>
                     Fimestic S.I. A.I.E. - Retama 3, 3º 28045 Madrid
                     Telefono: +34 91.337.07.40 - Fax: +34 91.527.96.75


> Albert FEDIDA escribió en mensaje <6uarvd$pdl$1_at_front3.grolier.fr>...

>Do someone know if some tool exists about converting
>an Access SQL query to an Oracle one ?
>
>Also, I look for a much powerful SQL editor for Personal Oracle than
>"PLUS33W". Where can I find it ?
>
>Thanks a lot
>
>Albert.
>
>
Received on Wed Sep 23 1998 - 09:21:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US