rains_xy的专栏

function:   create or replace function    F_GET_ACC_GROUP_USED(RT_GROUP_ID IN NUMBER) RETURN VARCHAR2 IS   v_count NUMBER; BEGIN   SELECT count(1) into v_count FROM cm.cm_concentration_acc_se

通过sql语句查看数据，如果时间比较久了就没了 select * from your_table_name as of timestamp to_timestamp('2013-10-10 3:13:00', 'yyyy-mm-dd hh24:mi:ss');

set define off; declare   is_exist  NUMBER;   alter_sql VARCHAR2(4000) := 'alter table tableName add columnName VARCHAR2(100 BYTE) DEFAULT null'; begin   select count(1) into is_exist from dba_ta