iteye_9557的博客

1. select TABLE_NAME, COLUMN_NAME from USER_TAB_COLUMNS where table_name = 'P_RPTDATA_APP_LOG';//P_RPTDATA_APP_LOG是表名 2. select * from dba_tab_columns ; 3. select * from dba_tab_cols;

Oracle计算时间差表达式 --取第几天的数据。 select * from table where trunc(sysdate)-trunc(cr)=1; select * from table where trunc(sysdate)-trunc(cr)=2; select * from table where trunc(sysdate)-trunc(cr)=8;...