sudo sed -i 's/net.ipv6.bindv6only\ =\ 1/net.ipv6.bindv6only\ =\ 0/' \
/etc/sysctl.d/bindv6only.conf && sudo invoke-rc.d procps restart
cd c:\tmp\apex sqlplus "sys/syspass as sysdba" @apexins SYSAUX SYSAUX TEMP /i/
sqlplus "sys/syspass as sysdba" @apxchpwd
@apex_epg_config c:\tmp
alter user anonymous account unlock;
EXEC DBMS_XDB.SETHTTPPORT(8080);
SET SERVEROUTPUT ON
DECLARE
l_configxml XMLTYPE;
l_value VARCHAR2(5) := 'true'; -- (true/false)
BEGIN
l_configxml := DBMS_XDB.cfg_get();
IF l_configxml.existsNode('/xdbconfig/sysconfig/protocolconfig/httpconfig/allow-repository-anonymous-access') = 0 THEN
-- Add missing element.
SELECT insertChildXML
(
l_configxml,
'/xdbconfig/sysconfig/protocolconfig/httpconfig',
'allow-repository-anonymous-access',
XMLType('' ||
l_value ||
' '),
'xmlns="http://xmlns.oracle.com/xdb/xdbconfig.xsd"'
)
INTO l_configxml
FROM dual;
DBMS_OUTPUT.put_line('Element inserted.');
ELSE
-- Update existing element.
SELECT updateXML
(
DBMS_XDB.cfg_get(),
'/xdbconfig/sysconfig/protocolconfig/httpconfig/allow-repository-anonymous-access/text()',
l_value,
'xmlns="http://xmlns.oracle.com/xdb/xdbconfig.xsd"'
)
INTO l_configxml
FROM dual;
DBMS_OUTPUT.put_line('Element updated.');
END IF;
DBMS_XDB.cfg_update(l_configxml);
DBMS_XDB.cfg_refresh;
END;
/
Element updated.exec dbms_xdb.setListenerLocalAccess(l_access => FALSE);
drop table test_merge;
create table test_merge as select 1 m, 2 n from dual;
alter table test_merge add constraint test_merge_chk check (m <= n);
update test_merge set n = m - 1;
rollback;
select * from test_merge;
merge into test_merge tgt
using (select m, m-1 n from test_merge) src
on (tgt.m = src.m)
when matched then update set tgt.n = src.n;
commit;
select * from test_merge;
Таблица создана.
Таблица изменена.
update test_merge set n = m - 1
*
ошибка в строке 1:
ORA-02290: нарушено ограничение целостности CHECK(XXX.TEST_MERGE_CHK)
Откат завершен.
M N
---------- ----------
1 2
1 строка объединена.
Фиксация обновлений завершена.
M N
---------- ----------
1 0
merge into test_merge tgt
using (select m, m-1 n from test_merge) src
on (tgt.m = src.m)
when matched then update set tgt.n = src.n
when not matched then insert (m) values(null) where 1 = 0;
Сообщения
Все комментарии
