4. Using the editor, create a controlfile names.ctl with these settings:
load datainfile 'names.txt'badfile 'names.bad'truncateinto table namesfields terminated by ','trailing nullcols(first,last)This controlfile will truncate the target file before carrying out the insert.
Bạn đang xem 4. - OCA OCP ORACLE DATABASE 11G A LL IN ONE EXAM GUIDE P89 DOC