Home » SQL & PL/SQL » SQL & PL/SQL » External tables and character set
External tables and character set [message #213996] Sat, 13 January 2007 07:55 Go to next message
Messages: 3
Registered: December 2006
Junior Member
I have a txt file with several columns and i want to create an external table which will link in the text file. However, there is a column which contains greek characters. The external table is created successfully, but when i query the table, the greek characters appear as ??. The sql code for the external table is:

create table test
field1 varchar2(100),
field2 varchar2(100)
organization external
type oracle_loader
default directory ext_dir2
access parameters
records delimited by '\n'
badfile 'test_bad.txt'
discardfile 'test_discard.txt'
logfile 'test_log.txt'
skip 0
fields terminated by '\t' optionally enclosed by '"'
missing field values are null
location ('test.txt')
reject limit unlimited;

The nls parameters are all set in Greek. How can I define the character set of the datafile?
Re: External tables and character set [message #214007 is a reply to message #213996] Sat, 13 January 2007 08:53 Go to previous message
Messages: 2794
Registered: April 2006
Senior Member
Check the CHARACTERSET parameter for External Tables.
Previous Topic: Query regarding Index?
Next Topic: about sql query
Goto Forum:

Current Time: Sat Oct 22 07:05:34 CDT 2016

Total time taken to generate the page: 0.08969 seconds