テーブルの作成日時を知りたい

表の作成日時はわかりますか？ 【OKWave】

SQL自体はこんな感じ。

select object_name,object_type,
to_char(created,'yyyy/mm/dd hh24:mi:ss') as created
from user_objects
where object_name = 'EMP';

Oracleだとテーブルとかデータベースとかひっくるめて「オブジェクト」と呼ばれるそうなので、とりあえずuser_objectの情報を眺めればいいんじゃないかなって。

ＯＲＡＣＬＥ／オラクル・データディクショナリ（DBA_OBJECTS）

diff で差分ファイルのみの表示

diffで差分ファイル名のみ表示する - mononocoの日記

cheat diffでやると、ちゃんとqオプションも載ってる。

# To view the differences between two files:
diff -u version1 version2

# To view the differences between two directories:
diff -ur folder1/ folder2/

# To ignore the white spaces:
diff -ub version1 version2

# To ignore the blank lines:
diff -uB version1 version2

# To ignore the differences between uppercase and lowercase:
diff -ui version1 version2

# To report whether the files differ:
diff -q version1 version2

# To report whether the files are identical:
diff -s version1 version2

# To diff the output of two commands or scripts:
diff <(command1) <(command2)