dababase 差异

取得所有表

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');