Oacle SQL*Loader allows you to specify several
variations of the tab character in the control files syntax. There are
several ways to load table delimited data into Oracle.
In the control file, you can specify a tab as a backslash t, one way to describe the tab character:
fields terminated by '\t'
Any character can be used as a delimiter and you can specify it's hex representation in the SQL*Loader control file. The hexadecimal 09 represents the tab character:
fields terminated by x'09'
In the control file, you can specify a tab as a backslash t, one way to describe the tab character:
fields terminated by '\t'
Any character can be used as a delimiter and you can specify it's hex representation in the SQL*Loader control file. The hexadecimal 09 represents the tab character:
fields terminated by x'09'
