How do I delete rightmost characters in oracle?

Posted by Jiltin     Tags: , 12 February, 2009    551 views    (0) Comment

How do I delete rightmost characters in oracle? The answer is: Verification: SELECT Any_Column, substr(Any_Column,1,length(Any_Column)-1)  FROM Table_name Actual Execution UPDATE Table_name SET Any_Column=substr(Any_Column,1,length(Any_Column)-1)         Read Full Article (Click here)...

Categories : Oracle Applications Tags : ,

Awk script Usage description linux/unix help page

Posted by Jiltin     Tags: , , , 20 November, 2008    9,710 views    (0) Comment

AWK syntax: awk [-Fs] “program” [file1 file2...] # commands come from DOS cmdline awk ‘program{print “foo”}’ file1 # single quotes around double quotes # NB: Don’t use single quotes alone if the embedded info will contain the # vertical bar or redirection arrows! Either use double quotes, or (if # using 4DOS) use backticks around the single quotes: `’NF>1′` # NB: since awk will accept single quotes around arguments Read Full Article (Click here)...

Categories : Scripts Unix Tags : , , ,