取得所有表
mysql
SHOW TABLES
oracle
select Object_Name from all_objects where Object_Type='TABLE'
取得指定schema下面的表
oracle
select Object_Name from all_objects where Object_Type='TABLE' and OWNER='demoschema'
sql snippets
select * from package_specification WHERE TRUNC(originated) = TO_DATE('2011/11/18', 'YYYY/MM/DD');