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)... 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 NLS_LANG=American_America.AL32UTF8
sqlplus / AS sysdba
ALTER SESSION SET CONTAINER = FREEDB1;
@
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
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è
ten in Richtung from => to
PGQL> select a.valueA as from ,e.value,b.valueA as to from match ( (a)-[e]->(b) );
FROM VALUE TO
______... en in der anderen Richtung
PGQL> select a.valueA as from ,e.value,b.valueA as to from match ( (a)<-[e]-(b) );
FROM VALUE TO
______
er ein Library Objekt anlegen<code sql> sqlplus / as sysdba
CREATE OR REPLACE LIBRARY SKA_MQ_CONNECT_DDL AS 'C:\oracle\products\12.1.0.2\dbhome_1\BIN\clr\SKA... CE FUNCTION callExternalDDLProc
RETURN VARCHAR2 AS LANGUAGE C
NAME "Class1.getData"
LIBRARY SYS.... Directory Eintrag, neu anlegen:
<code>
connect / as sysdban
create directory ORACLECLRDIR as 'C:\orac
select (sysdate-(sysdate-1/2) ) / ( 1/(24*60)) as min_dif from dual;
MIN_DIF
------------
... select to_date('06.12.'|| to_char(1899+rownum)) as dat from all_objects where rownum < 150
)
where... from ( select systimestamp - (systimestamp - 1) as interval_difference
from dual )
... stamp - (TIMESTAMP '1970-01-01 00:00:00 GMT') ) as interval_difference FROM dual ) ;
---
1606159