PRIMARY KEY ( ID ) ;
COMMENT ON TABLE Documents IS 'Store the file information' ;
COMMENT ON COLUMN Documents.ID IS 'Primary Key' ;
COMMENT ON COLUMN Documents.Filename IS 'Name of the file on disk' ;
COMMENT ON COLUMN Documents.FileTyp IS 'Typ of the file' ;
COMMENT ON COLUMN Documents.
r**
**18c**
<note important>Oracle Multimedia is deprecated in Oracle Database Release 18c, and ma... DBMS_OUTPUT.PUT_LINE('The destination is null');
WHEN ORDSYS.ORDImageExceptions.DA... LOCAL THEN
DBMS_OUTPUT.PUT_LINE('Data is not local');
WHEN ORDSYS.ORDImageExceptio... _OUTPUT.PUT_LINE('dest.source.localData attribute is null');
when others then
DBM
of SQL macro: use of SQL macro inside WITH clause is not supported
64630. 00000 - "unsupported use of... of SQL macro: use of SQL macro inside WITH clause is not supported
64630. 00000 - "unsupported use of... e
, case
when k.ZENTRALEKUNDENNUMMER is null then
k.INSTITUT||'-'||k.KUNDENNUM... STITUT||'-1'
when k.ZENTRALEKUNDENNUMMER is not null and k.ZENTRALINSTITUT is not null then
PRIMARY KEY ( ID ) ;
COMMENT ON TABLE Documents IS 'Store the file information' ;
COMMENT ON COLUMN Documents.ID IS 'Primary Key' ;
COMMENT ON COLUMN Documents.Filename IS 'Name of the file on disk' ;
COMMENT ON COLUMN Documents.FileTyp IS 'Typ of the file' ;
COMMENT ON COLUMN Documents.
)==
Typ definieren:
<code plsql>
TYPE myPlsqltab is TABLE OF varchar2(2000) index by binary_integer;
... ver gaps
v_count := v_texte.first;
while v_count is not null
loop
dbms_output.put_line('element #'... alten:
<code sql>
declare
type t_emp_lookup_tab is table of emp_lookup.id%type INDEX BY varchar2(16)... ptab t_emp_lookup_tab;
cursor c_emp_lookup
is
select id
, max (deptno) as deptno
erstellen:
<code plsql>
create procedure setRole
is
begin
apex_authorization.enable_dynamic_groups ... auswählen
* Name vergeben
* Scheme Type "Is in Group" wählen
* Eine Gruppe einfach eintr... l_spc.sql>
create or replace package ldap_ad_util
is
-- +===========================================... he ad
-- check how the loginname in your domain is defined!
g_ad_user_type varchar2(255) := 'cn=';
d for orarun:
OracleOraDB12Home1ClrAgent service is being created.
OracleOraDB12Home1ClrAgent service... successfully.
OracleOraDB12Home1ClrAgent service is starting..
OracleOraDB12Home1ClrAgent service was... uch : Configuring Listener To Spawn EXTPROC Agent Is Not Working in 12.2, EXTPROC_CONNECTION_DATA Is Not Getting Resolved. (Doc ID 2326592.1)
<fc #800000
tools.entrypoint.WebApplicationRequestEntryPoint] is not a Servlet - das ist noch nicht kompatibel! </... ou for installing Oracle APEX 23.1.0
Oracle APEX is installed in the APEX_230100 schema.
..
timing fo... UBLIC_USER** - The minimally privileged account is used for Oracle Application Express configuration... and newer, for non-CDB, for CDB where Oracle APEX is not installed in the root, and for PDB where APEX
ility environments
# => was ist quic?
# -- HTTP/3 is the latest iteration of the HTTP protocol with on... org/
License : GPLv2+
Description : HAProxy is a TCP/HTTP reverse proxy which is particularly suited for high
: availability environmen... make this warning disappear.
Configuration file is valid
</code>
dhparams.pem erzeugen (dauert etw
or replace package search_CC
as
type num_arry is table of number
index by b... with the LuhnMod10 alogrithmus
1 Sucess - is a Luh10 Number
-1 Invalid
*/
functio... pls_integer default 1)
return varchar2
is
v_cc varchar2 (32000);
v_return... CCText (p_text varchar2)
return varchar2
is
v_textstring varchar2 (32000) := p_text;
MP
SQL> SELECT COUNT(*) FROM scott.emp;
-- All is fine
-----------------------------------------... PROCEDURE procTestRoleRighst
AUTHID CURRENT_USER
IS
v_count pls_integer;
BEGIN
BEGIN
SELECT CO... grams.htm#LNPLS599
- A unit whose AUTHID value is **CURRENT_USER** is called an **invoker's rights** unit, or **IR unit**.
- A unit whose AUTHID val
ime ( p_starttime timestamp)
return number
is
v_endtime timestamp;
v_runtim... -- check if parameter exits
if :P1_FILENAME is not null
then
v_charset := nvl( :P1_CHAR...
-- check again if stage table is empty
-- check that this table is empty
select count(*) into v_rec_count from
n Express 5.0.4.00.12
Oracle Application Express is installed in the APEX_050000 schema.
The structu... o the Application Express administration services is as follows:
http://host:port/pls/apex/apex_admin ... to the Application Express development interface is as follows:
http://host:port/pls/apex (Oracle HTT... _PUBLIC_USER** - The minimally privileged account is used for Oracle Application Express configuration
les Ordner an das Template gehängt:
<code sql>
..
IS
..
cursor c_news_letter_images(p_app_id number)
is
select replace(filename,'newsletter_images/','... ien der Mail hinzugefügt werden.
<code plsql>
..
IS
cursor c_get_attachment(p_file_id number)
is
select f.FILENAME
, f.MIMETYPE
..............................++++++
....++++++
e is 65537 (0x10001)
Enter pass phrase for server.key:... bit long modulus
................++++++
.++++++
e is 65537 (0x10001)
Enter pass phrase for server.key:... certificate request.
What you are about to enter is what is called a Distinguished Name or a DN.
There are quite a few fields but you can leave some blan