Re: [URGENT] Access Table into Oracle

From: Philippe Michel <nospam_at_nospam.com>
Date: Mon, 29 Apr 2002 14:24:42 +0200
Message-ID: <3CCD3B8A.92C2CB5A@nospam.com>

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

Received on Mon Apr 29 2002 - 07:24:42 CDT