Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. EvansEd

    Simultaneous Runs

    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...
  2. EvansEd

    Loading from .xls file in SQL*Loader

    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!
  3. EvansEd

    Loading from .xls file in SQL*Loader

    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?
  4. EvansEd

    Checking for values in same table

    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...
  5. EvansEd

    Loading 1 table with 2 datafiles

    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) ?
  6. EvansEd

    Skipping empty rows from data file

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

    Skipping empty rows from data file

    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.
  8. EvansEd

    Loading 2 tables from a .ctl (control) file

    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...
  9. EvansEd

    Splitting a value in one column into two separate columns

    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...

Part and Inventory Search

Back
Top