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
Posted by Huiming Li at 4:45 AM No comments:

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}'
Posted by Huiming Li at 7:14 AM 1 comment:
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Blog Archive

  • ►  2021 (2)
    • ►  June (1)
    • ►  May (1)
  • ►  2019 (1)
    • ►  May (1)
  • ►  2017 (1)
    • ►  August (1)
  • ►  2016 (1)
    • ►  February (1)
  • ►  2015 (1)
    • ►  November (1)
  • ►  2013 (4)
    • ►  November (3)
    • ►  April (1)
  • ►  2012 (2)
    • ►  January (2)
  • ►  2010 (4)
    • ►  December (1)
    • ►  October (1)
    • ►  September (1)
    • ►  April (1)
  • ►  2008 (5)
    • ►  December (1)
    • ►  November (1)
    • ►  October (1)
    • ►  September (1)
    • ►  June (1)
  • ▼  2007 (7)
    • ►  December (1)
    • ►  October (1)
    • ►  August (1)
    • ►  May (2)
    • ▼  January (2)
      • Scalar query and parallel query
      • (Unix/Linux Shell) How many lines in a file?
  • ►  2006 (24)
    • ►  December (3)
    • ►  November (1)
    • ►  August (3)
    • ►  July (1)
    • ►  May (2)
    • ►  April (3)
    • ►  March (4)
    • ►  February (7)

About Me

Huiming Li
Life is a transaction with no option to issue a rollback.
View my complete profile

Links

  • Ask Tom
  • If you read chinese
  • Chinese Chess
Simple theme. Theme images by tjasam. Powered by Blogger.