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!

Recent content by howtowork

  1. howtowork

    Removing parts of data in a column

    hi everyone, I am fairly new so easy things trip me up, I have data in a column that is entered as 'BE-333' or 'REW-478' or 'BD222' or 'BD-44RD'. which of course shouldn't have been entered that way. My problem is how to go about seperating the fisrt set of characters from the numbers (less...
  2. howtowork

    Sql loader

    Thanks, I will give it a try.
  3. howtowork

    Sql loader

    Hi, I am trying to load a csv file however the arrangement of the columns in the file is different than the table I am inserting the data into. Is there a way get the ctl and load the columns in the csv file to match the new table? csv: col1, col2, col3 but lets say my table's headings...
  4. howtowork

    SQL LOADER

    Hi, I am attempting to use sql loader only to find that it is not installed. I have found some sites that say it is in the Oracle Client Software utilities installation CD, but have yet to find this on their site, or is this included in the 8i enterprise cd? Thanks jay
  5. howtowork

    flat files and blobs

    Hi all, I was just wondering what is the syntax for (or if it is even needed) for a blob when creating a flat file to convert a db. Such as to_char for a numeric field or am I just lost? Or does anyone know of a good site to find more info on flat files and loading. Thanks, jason
  6. howtowork

    Importing data from Access '02

    Hi all, I am pretty new at this db thing and was given a project that involves importing data from access '02 to oracle 8i. So here is my question what is the best way to go about this? Do I create tables first then import or import the whole db or link the tables? I have looked around for...
See more

Part and Inventory Search

Back
Top