Oracle SQL tips and tricks + Unix/Linux Work Log
See how much a single Oracle SQL statement can do... Plus some Unix/Linux Work Log
Saturday, January 27, 2007
Scalar query and parallel query
If you have a scalar query in the select list, the whole query will not work in parallel mode even if you give a parallel hint
Thursday, January 18, 2007
(Unix/Linux Shell) How many lines in a file?
Linux (FC6)
wc -l tx.txt | cut -f 1 -d " "
Solaris
wc -l tx.txt | sed -e 's/^ *//' | cut -f 1 -d " "
OR
wc -l txt.txt | awk '{print $1}'
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)