Connor and Chris will both be at AI World from October 12 to October 17 , the premier Oracle conference of 2025. If you're in Vegas, please come say Hi or pop into our sessions
Thanks for the question, Marcelo.
Asked: May 22, 2017 - 8:00 pm UTC
Last updated: May 24, 2017 - 3:11 am UTC
Version: 11g
Viewed 10K+ times! This question is
SQL> CREATE TABLE t ( 2 x VARCHAR2(50) 3 ) 4 ORGANIZATION EXTERNAL ( 5 TYPE ORACLE_LOADER 6 DEFAULT DIRECTORY temp 7 ACCESS PARAMETERS ( 8 RECORDS DELIMITED BY NEWLINE 9 FIELDS TERMINATED BY ',' 10 MISSING FIELD VALUES ARE NULL 11 ( 12 x CHAR(50) 13 ) 14 ) 15 LOCATION ('t.dat') 16 ); Table created. SQL> SQL> SQL> select * from t; X -------------------------------------------------- "\"Taiwan Mobile\"" SQL> SQL> select replace(trim('"' from replace(x,'\"',chr(0) )),chr(0),'"') 2 from t; REPLACE(TRIM('"'FROMREPLACE(X,'\"',CHR(0))),CHR(0) -------------------------------------------------- "Taiwan Mobile"
Share and learn SQL and PL/SQL; free access to the latest version of Oracle Database!
Classes, workouts and quizzes on Oracle Database technologies. Expertise through exercise!