Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: [URGENT] Access Table into Oracle
SQL> select "OMIKorr" from qq;
is better !! Thank you very much ...!
Phil.
Philippe Michel wrote:
> Niall Litchfield wrote:
>
> > enclose in quotation marks.
>
> you means something like this ??
>
> SQL> select 'OMIKorr' from qq;
>
> 'OMIKOR
> -------
> OMIKorr
> OMIKorr
>
> That does not run...
>
> Philippe
>
> > --
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission UK
> > *****************************************
> > Please include version and platform
> > and SQL where applicable
> > It makes life easier and increases the
> > likelihood of a good answer
> >
> > ******************************************
> > "Philippe Michel" <nospam_at_nospam.com> wrote in message
> > news:3CCD34FD.7D7FAACD_at_nospam.com...
> > > Hello,
> > >
> > > I have imported an MS-Access Table into an Oracle dbs. An I will have to
> > > do this some times in the futur.
> > >
> > > The field names are in lower cases under Oracle ( the Table name too,
> > > but I can easylly correct this). How can I write an SQL command with
> > > lower case field names ?
> > >
> > > many thanks for any help,
> > >
> > > --
> > > - Philippe MICHEL
> > >
> > >
>
> --
> - Philippe MICHEL
> - mailto:phm.michel_at_himmelsbach-gmbh.de
> - mailto:phm.michel_at_libertysurf.fr
>
> - Himmelsbach GmbH
> - In der Spöck 10
> - D-77656 Offenburg
> - tel 0781/99 01 85 36
> - http://www.himmelsbach-gmbh.de
-- - Philippe MICHEL - mailto:phm.michel_at_himmelsbach-gmbh.de - mailto:phm.michel_at_libertysurf.fr - Himmelsbach GmbH - In der Spöck 10 - D-77656 Offenburg - tel 0781/99 01 85 36 - http://www.himmelsbach-gmbh.deReceived on Mon Apr 29 2002 - 07:26:01 CDT