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...
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...
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...
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...
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
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.