개발자인생

select  *

from    AAA

where dbms_lob.instr(clobcol, 'need')>0

SELECT *
  FROM (SELECT 'AAA' AS NAME FROM DUAL
  UNION ALL
  SELECT 'BBB' AS NAME FROM DUAL
  UNION ALL
  SELECT 'CCC' AS NAME FROM DUAL
  UNION ALL
  SELECT 'DDD' AS NAME FROM DUAL)
;

SELECT MAX(DECODE(MOD(RN, 5), 1, NAME)) NAME1,
    MAX(DECODE(MOD(RN, 5), 2, NAME)) NAME2,
    MAX(DECODE(MOD(RN, 5), 3, NAME)) NAME3,
    MAX(DECODE(MOD(RN, 5), 4, NAME)) NAME4,
    MAX(DECODE(MOD(RN, 5), 0, NAME)) NAME5
  FROM (SELECT ROWNUM RN, NAME
    FROM (SELECT *
      FROM (SELECT 'AAA' AS NAME FROM DUAL
                        UNION ALL
                        SELECT 'BBB' AS NAME FROM DUAL
                        UNION ALL
                        SELECT 'CCC' AS NAME FROM DUAL
                        UNION ALL
                        SELECT 'DDD' AS NAME FROM DUAL)))
 GROUP BY CEIL(RN / 5);

prifex='date +%Y%m%d'
echo $prefix
prefix=`date +%Y%m%d%H%M`
echo

find . -name "*.*" -exec grep Search {} \; -print  

tar cvf - access.200705* | gzip > 200705_2_1.tar.gz : tar로묶으면서 압축 

gunzip -c nohup.out.gz | grep cms : gz파일 압축풀지않고 추출 

ps -f -uweblogic | grep groupware | grep java | awk '{ print $2 }' | xargs kill -9
ln -s /share/aa/bb/rwk ./rwk