ERPstuff - Oracle EBS Community

HI friend
plese tell me answers for these questions i am waiting for u r reply

1)If you are working in sql*loader, How will you transfor the data into XLSheet? and suppose my data having 10000 lines, but my requirement is each page contains 50 line, and forvery 10 line take one blank line means empty? plese provde answer I did not get anyware ?

2)What is use of "optionalyenclosed by " in sql *loader?
3)what is Delimeter?

Thanq
ssrappstech@gmail.com

Hi, Friend,
1)we cannot transfer data into xl sheet through SQLLOADER you have to use UTL_FILE package to make data into xlsheet or else.
2)" " is known sqlloader it optional seprated column in .ctl file and it seprated the fields.

hope the answer are right . if not let me know
regards
roshan