sql 备忘

select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') from dual;

select dbms_metadata.get_ddl('TABLE','TABLE_NAME') from dual;