摘要：由于书记没有提供源代码，本人录入后提供给大家，仅供学习：剑破冰山oracle 开发艺术10.4源代码1，employeeinfo表create table employeeinfo(emp_id int, emp_name varchar2(50), dept_id int, hire_date date, salary int);insert into employeeinfo (emp_id, emp_name, dept_id, hire_date, salary)values (100, 'Wang John', 10, to_date('1990-01-01& 阅读全文

摘要：日常小技巧：1,修改oracle windows客户端字符集regeditHKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/KEY_oracle10g设置NLS_LANG=AMERICAN_AMERICA.AL32UTF8;NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK2,修改归档日志空间大小和存储路径--查看select name, space_limit / 1024 / 1024 space_limit_mb, space_used / 1024 / 1024 space_used_mb from v$recovery_file_ 阅读全文

摘要：查看oracle隐藏参数select a.ksppinm name, b.ksppstvl value, a.ksppdesc description from x$ksppi a, x$ksppcv bwhere a.indx = b.indx and a.ksppinm like '%_kghdsidx_count%'; 阅读全文

摘要：grant select on v_$session to hr;select view_name,view_definition from v$fixed_view_definition where view_name = 'V$SESSION';select count(*) from v$fixed_table where name like 'V$%';select count(*) from v$fixed_table where name like 'GV%';select * from v$fixed_table;select * 阅读全文

摘要：调整rac 阅读全文

摘要：oracle length() lengthb() 阅读全文

摘要：oracle hr用户建立 阅读全文

摘要：oracle构造过程 阅读全文

摘要：oracle动态SQL 阅读全文