tion customerId
return varchar2
SQL_MACRO(SCALAR)
as
begin
return 42;
end customerId;
</code>
Auf... en(
SK number(11) GENERATED BY DEFAULT ON NULL AS IDENTITY
, institut varchar2(4)
, kundennummer... INSTITUT||'-1-'||k.ZENTRALEKUNDENNUMMER
end as InteralKDNr
from Kunden k
group by Kundenname... rInstitut, ZentralInstitut, ZentraleKundennummer) as InteralKDNr
from Kunden k
group by Kundenname,I
Node => Support Entitlement for Java SE When Used As Part of Another Oracle Product (Doc ID 1557737.1)... Service eintragen!
#alternativ falls ein Cluster/ASM DB = >oracle-ohasd.service
#After=dbora.service
... nd in den richtigen Container wechseln
sqlplus / as sysdba
ALTER SESSION SET CONTAINER = FREEDB1;
... rt NLS_LANG=American_America.AL32UTF8
sqlplus / as sysdba
# falls cdp richtigen Container setzen!
A
rt JAVA_HOME=/usr/lib/jvm/jdk-19-oracle-x64
sql / as sysdba
help rest
REST
------
Use REST to expor... Node => Support Entitlement for Java SE When Used As Part of Another Oracle Product (Doc ID 1557737.1)... ername: sys
Enter the database password for SYS AS SYSDBA:
Connecting to database user: SYS AS SYSDBA url: jdbc:oracle:thin:@//10.10.10.90:1521/SRV_GPID
ula) [[https://docs.oracle.com/database/121/CCREF/ascore.htm#CCREF1475|Scoring Algorithm for Word Quer... n der Beispieldaten und indizieren:
<code sql>
-- as sys
-- grant rights to create the index
connect sys as sysdba
grant CTXAPP to gpi
connect gpi/gpi
cre... >
select CTX_THES.SYN('automobile','t_fahrzeuge') AS SYN from dual;
</code>
siehe dazu [[dba:oracle_te
search_id number(11) GENERATED BY DEFAULT ON NULL AS IDENTITY
, PK_ID number(11)
, PK_TABLENAME varc... he blob
-- not nesseary if you use blob as datastore
/*
dbms_lob.open(v_
select replace(filename,'newsletter_images/','') as filename
, blob_content
, mime_type
, replace(filename,'newsletter_images/','') as content_id
from apex_application_files
where f...
select replace(filename,'newsletter_gpi/','') as filename
, blob_content
, mime_type
, replace(filename,'newsletter_gpi/','') as content_id
from apex_application_files
where f
vely
* n: to make the dot (.) match new lines as well
* m: to make ^ and $ match beginning and... +)([[:alpha:]]+)[[:space:]]+\2($|[[:space:]]+)') as example
from dual
/
example
-------
DE DE
<... +[.][[:digit:]]+'
,'20.30') as test_string from dual;
TEST_STRING
-------------... xp_replace('Gunther,Pippèrr','(.*),(.*)','\2 \1') as example from dual;
example
---------------
Pippè
ure.ac
./configure
make
make install
#install asciidoc
# see http://www.methods.co.nz/asciidoc/INSTALL.html
# Download the zip file with a browser
# not working wget -O asciidoc-8.6.9.zip http://sourceforge.net/projects/asciidoc/files/latest/download
unzip asciidoc-8.6.9.