Search results for query: *

I am sort of new to UNIX and don't know much of the commands, there I have this question to ask of you guys. I have a unix script that is on a schedule to run every friday at 5pm, and to also run on last day of month at 5pm. There will be cases when the two criterias above are true, therefore...

DATALOAD did not work because my Oracle is on a UNIX box, not Windows. If I convert my .xls file to .csv, it looses the Chinese characters, they turn into '?' (question marks), therefore I can't do that! Any other suggestions would be greatly appreciated!

I have a .xls file with double-byte characters (e.g. Chinese lettters). If I save this file as a .CSV,.DAT, etc, I loose the double-byte characters. Does anyone know how I can load a .xls file using SQL*LOADER w/o losing the double-byte characters?

Can someone please help me with this... I am trying to write an SQL statement for the following: If REC_TYPE = '02' and LOT_NBR is null, look for REC_TYPE = '03' with same DLVRY_KEY as REC_TYPE = '02' and load those records. If there is no REC_TYPE = '03' for a particular DLVRY_KEY, load...

How can I load 1 table with 2 datafiles with skipping a different number of records from each datafile (example: datafile1 skip=4 and datafile2 skip=3) ?

I have a spreadsheet(.csv) file, therefore I can't use POSITION. Any other suggestions?

I'd like to know how to skip empty rows from a data file when writing my sql loader .ctl file? There will be empty rows in the data file, but I just don't know where they will be.

I wanted to load two different data files, one after the other into the same table. Can I do this? (see below) If not, what would be the correct structure to load two files? OPTIONS ( SILENT=(FEEDBACK) ) LOAD DATA INFILE "$DATFILE" BADFILE "$BADFILE" INFILE...

How can I split a value that will be read-in into 1 column, and transferred to another table into two seperate columns? Ex. Table A: Product 123456-001 data transfered into Table B: Product_Num Product_Size 12345...