Re: Reserved word? or not?
- From: "Howard Latham" <howard.latham@xxxxxxxxx>
- To: andrew.clarke@xxxxxxxxxx
- Date: Wed, 24 Sep 2008 09:42:19 +0100
Er isn't that SQL not PLSQL?
2008/9/24 Clarke, Andrew <andrew.clarke@xxxxxxxxxx>
> Hello Jack
>
> > We have an external table that reads from a datafile just fine in Oracle
> 9i.
> > However we upgraded our test environment to 10G and now it complaints
> about
> > the column name "LANGUAGE". It expects double quotes.
>
> Hmmm, puzzling. It works for me without a hitch...
>
> clarkea:~$ sqlplus apc
>
> SQL*Plus: Release 10.2.0.4.0 - Production on Wed Sep 24 09:01:36 2008
>
> Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
>
> Enter password:
>
> Connected to:
> Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
> With the Partitioning, OLAP, Data Mining and Real Application Testing
> options
>
> SQL> create table my_table (language varchar2(3))
> 2 /
>
> Table created.
>
> SQL> create table my_table_ext
> (
> language varchar2(10)
> )
> ORGANIZATION EXTERNAL
> (
> TYPE ORACLE_LOADER
> DEFAULT DIRECTORY clarkea
> ACCESS PARAMETERS
> (
> records delimited by newline
> fields terminated by ','
> missing field values are null
> )
> LOCATION ('languages.csv')
> )
> PARALLEL 4
> REJECT LIMIT 1000
> /
> 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
> 17 18 19
> Table created.
>
> SQL> desc my_table
> Name Null? Type
> ----------------------------------------- --------
> ----------------------------
> LANGUAGE VARCHAR2(3)
>
> SQL> desc my_table_ext
> Name Null? Type
> ----------------------------------------- --------
> ----------------------------
> LANGUAGE VARCHAR2(10)
>
> SQL>
>
> Cheers, APC
>
> A P Clarke
> Software Architect
> Logica UK Public Sector Division
> Stephenson House
> 75 Hampstead Road
> London
> UK
> NW1 2PL
> Direct Tel: +44 (0)207 230 3160
> Fax: +44 (0)207 446 1352
> Email: andrew.clarke@xxxxxxxxxx
>
>
> This e-mail and any attachment is for authorised use by the intended
> recipient(s) only. It may contain proprietary material, confidential
> information and/or be subject to legal privilege. It should not be copied,
> disclosed to, retained or used by, any other party. If you are not an
> intended recipient then please promptly delete this e-mail and any
> attachment and all copies and inform the sender. Thank you.
>
--
Howard A. Latham
Other related posts:
