以下のようなテキストを hoage@hogehoge[hoge]$ cat hogehoge.dat a b c d e f g h i 先頭１文字目がaとgのものだけを抽出できたりする hoge@hogehoge[hoge]$ cat hogehoge.dat | grep -E '^a|^g' a b c g h i

set lines 120 set pages 100 set term off tti off clear col col TABLESPACE_NAME format a15 col "SIZE(KB)" format a19 col "USED(KB)" format a19 col "FREE(KB)" format a19 col "USED(%)" format 990.99 select tablespace_name, to_char(nvl(total_b…

SELECT 1, 2 FROM DUAL UNION SELECT 2, 3 FROM DUAL MINUS SELECT 1, 2 FROM DUAL; ※参考 http://www.shift-the-oracle.com/sql/minus-operator.html