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

    Creating SQlldr CTL file with truncation at start.

    USe TRUNCATE instead of APPEND.
  2. jaid89

    Mercator to Oracle/Sybase

    Thanks Shrini. Hope you can excuse my ignorance... but I'm totally new at this so I have no clue how to go about this. I've studied several existing Mercator maps we have right now. But so far, those that exists goes the opposite of what I'm looking for, i.e. a procedure creates a text file...
  3. jaid89

    SELECT & concatenate some fields?

    you need a semi-colon after your order by statement (before your insert statement).
  4. jaid89

    Mercator to Oracle/Sybase

    Is it possible to create a mercator map that reads from an IDOC (output from SAP) and inserts it to a Sybase database and/or Oracle 8i?
  5. jaid89

    Produce text file with set positions using UTL FILE

    Thanks Dave! =)
  6. jaid89

    Produce text file with set positions using UTL FILE

    Hi, Currently, my procedure (using utl_file) writes output to a text file that is pipe delimited. Text file has 25 fields. Is it possible, instead of having it pipe delimited, to write each field in a set column number (i.e. field 1 would start at col 1, field 2 would start at col 10, etc)...

Part and Inventory Search

Back
Top