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!

  • Congratulations Chris Miller 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. antman03

    1z0-007 content q.

    Hi all, I'm preparing for the 1z0-007 test and I've got a sybex study guie by Dawes and Thomas. It describes the various single-line functions available in Oracle, and being someone who doesn't have much mathetical experience, some of them are quite bewildering. My question is what is the...
  2. antman03

    loading file into oracle

    OK I´ve worked out a way to load the file into oracle, but now another question. I´ve got data in a string in the following format X = "aaaaa|aaaaaa|bbbbbbb|cccccc||d|d|e" etc. Although the number of fields are constant the field lengths are variable so I can´t extract data using...
  3. antman03

    loading file into oracle

    Hi all, Doing maintenance on the thread search page so I don´t know if this has been asked before, so here goes. I want to load up a semi-colon delimited file into an oracle table. Whats the best way of doing it? I haven´t doen this before but of the top of my head there are a couple of...
  4. antman03

    retrieving only old files from a directory

    Hi all, I am trying to get a get a list of files which are over a certain date, I am aware that " ls -c -t " will sort files and bring back the newest files first in a directory but I need only those that are older than a certain date (that is not all of them). I suppose I need to...
  5. antman03

    SED one-liner?

    Hi, I think I got it now, I am using sed for a file with the following type of contents header data data data trailer: 229 sed '$N;s/trailer:\n/trailer: /' file Gives me what I was looking for Thanks anyway
  6. antman03

    SED one-liner?

    Dickiebird, yep that is the right spec, I couldn´t get the code typed in bold to work though I´m not really a unix expert. I was getting the line count using grep of data lines and wc -l, (isn´t there any way of this total being written directly to the end of the last line instead of starting...
  7. antman03

    SED one-liner?

    Hi all I have a file which contains a header, trailer and lines of data, I would like to append a count of the data lines in the file to the end of the trailer. For the moment I have managed to generate the line count on a seperate line at the bottom of the file. For now it seems that I have...

Part and Inventory Search

Back
Top