I use semi-colon (;) to close ...
and yes, it seems it needs old style joins ... this worked:
select distinct BARCODE, PROJECT
from DATACARRIER, SEIS_DISCRIPTION
where DATACARRIER.IDX = SEIS_DISCRIPTION.IDX
and LINE like 'U3%';
Thanks for your help!
...IDX, BARCODE, PROJECT
2 from DATACARRIER join SEIS_DISCRIPTION on DATACARRIER.IDX = SEIS_DISCRIPTION.IDX
3 where LINE like 'U3%';
from DATACARRIER join SEIS_DISCRIPTION on DATACARRIER.IDX = SEIS_DISCRIPTION.IDX
*
ERROR at line 2:
ORA-00933: SQL command not properly...
...where LINE like 'U3%';
select distinct IDX, BARCODE, PROJECT from DATACARRIER join SEIS_DISCRIPTION on DATACARRIER.IDX = SEIS_DISCRIPTION.IDX where LINE like 'U3%'
*
ERROR at line 1:
ORA-00933: SQL command not properly ended
Will this work as I think it should?
select unique IDX, BARCODE, PROJECT from DATACARRIER where IDX in (select idx from SEIS_DISCRIPTION where LINE like 'U3%');
thanks
...VARCHAR2(16)
QC_STATUS VARCHAR2(5)
I am trying to find all unique BARCODE and DATACARRIER values from DATACARRIER where LINE = U3* in SEIS_DISCRIPTION.
I know that te IDX value is the key - jsut not how to link the results!
Simple eh?
All help appreciated,
littleIdiot.
PS...
Thanks
I use infrarecorder at home - couldn;t get it to do what I want it to do - maybe I need to look into setting a bit more.
I'll look at Roxio - think I have that at home. Will check tonight.
Thanks - any other suggestions welcome!
Not sure if I'm in the right place but here goes anyway ...
I'm looking to burn all my MP3's to DVD as mp3's, in their current directory structure.
But it's about 29GB worth of data.
I want some software that allows me to just say "Burn that lot to DVD and if it goes over one DVD, then let me...
Ammendment:
If the output is able to have the OPTION of outputing the part I want (first part of the filename, without underscore or "." extension) AS WELL AS the full file path, as a QC method.
I note that my output has some dodgy results, and to check it, I would need to know what the...
...examples.
The following does pretty much what I want, it just takes a long time to run, and bugs me that it's so stupid!
egrep -vf exclude.list */*content* | awk '{print $11}' | awk -F"/" '{print $NF}' | awk -F"." '{print $1}' | awk -F"_" '{print $1}' | sort -u
Explanation:
egrep -vf...
...corrupted, or is the tar command smart enough to not bundle a file that is going to take it over the size limit, and put it into the next tar file instead?
I hope this makes *some* sense to *someone*!
I guess I could run it and see, but just wanted some tek-tips advice!
Cheers,
littleIdiot
Hi,
Simply really ... I have a pipe delimited text file and want to grep everything except the following text:
| N1
| N2
| N3
| N4
| N5
| N6
| N7
| N8
| N9
I have searched the FAQ's and this forum, but not really getting anywhere.
I think egrep and an input file listing my text will work...
Thanks for the help everyone.
I have found that the script does in deed output to a log file upon redirection - but only after 10 minutes or so - I assume it is filing a buffer and only puging once the buffer is full.
However this is probably good enough for our needs at the moment.
I think...
Turns out the redirect WAS working all along - just not fillign the log file for about 10 minutes or so ... I assume it was filling a buffer then writnig to the log file and waiting again ...
problem solved.
Thanks all for your help.
Thanks for the reply.
when I try redirection like that - or even the full file path of the compiled program, the log file is created but stays empty - and the program does not seem to run.
Yes - redirection works normally for everything else.
Unsure if this is the right forum, but I already tried UNIX and got no-where, hoping this give me more ...
I have a .c program I am running on Solaris.
As the program runs, it writes text out to the terminal window. I want to capture this text in a log file so that other users can tail -f the...
Your help is appreciated. We use netmeeting regularly here - but it is stil not a solution, just a work around.
It's very frustrating that the output is there on my screen but I can't log it ...
Ah well ...
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.