3。配置嵌入式PL/SQL网关
@apex_epg_config D:\app
alter user anonymous account unlock;
alter user hr account unlock;
alter user hr identified by orcl
4.核实oracle DB http服务器的端口
select dbms_xdb.gethttpport from dual;
设置端口
exec dbms_xdb.sethttpport(8081);
5.中文显示汉化
新建环境变量
NLS_LANG
American_America.AL32UTF8
American_America.ZHS16GBK
运行-》d:
cd D:\app\apex
sqlplus sys/orcl as sysdba
alter session set current_schema = APEX_040200
@D:\app\apex\builder\zh-cn\load_zh-cn.sql
核实和设置job_queue_processes参数，要至少20以上
select value from v$parameter where NAME = 'job_queue_processes';
alter system set job_queue_processes = 1000;
show parameter job;
核实和设置shared_servers
show parameter shared_servers;
alter system set shared_servers = 5 scope=both;
http://localhost:8081/apex/apex_admin
SQL%
sql%rowcount -- 影响了多少行
v_n := sql%rowcount;
dbms_output.put_line(v_n);

sql%notfound -- 如果update没有处理到数据，就insert into
if sql%notfound then
insert into tt values
end if;

ITPub博客

39

最新文章