Sys_guid()

The sys_guid() can used to genated unique varchar2 columns

Select sys_guid() from dual

Also, you can use it as default value in a table

Using sqlldr you can use  as 

Column expression "sys_guid()",