摘要：
declare r_return varchar2(200);v_sql varchar2(10000);CURSOR C_AGE IS select distinct usagename from dictusage;CURSOR C_AGE1 IS select * from dictusage 阅读全文
摘要：
SQL> show parameter session NAME TYPE VALUE java_max_sessionspace_size integer 0java_soft_sessionspace_limit integer 0license_max_sessions integer 0li 阅读全文
摘要：
declare i int :=0; p_dt_begin date; V_LDT_DATE date;begin while i<70 loop dbms_output.put_line('变量'||i); p_dt_begin:=to_date(to_char(sysdate-(i+1),'yy 阅读全文
摘要：
grant create view to hospital; --授予查询权限 grant select any table to hospital; --授予权限 grant select any dictionary to hospital; grant SELECT ON Yfgl_YPRuK 阅读全文
