N COLUMN Documents.FilePointer IS 'Bfile Pointer to the File' ;
COMMENT ON COLUMN Documents.MD5Hash IS 'Hash of the files to indentify dublicate files' ;
COMMENT ON COLUMN Do... comment on column thesaurus_phrases.ths_id is 'fk to the thesaurus name' ;
comment on column thesaurus... mment on column thesaurus_relations.ths_id is 'fk to the thesaurus name' ;
comment on column thesaurus
day format a5 heading "Day" JUSTIFY LEFT
select to_char(to_date(to_char(slday),'yyyymmdd'),'DD.MM') as slday
, decode(nvl(T01,0),0,'-',to_char(T01)) T01
, decode(nvl(T02,0),0,'-',to_ch
ATALINA_HOME/bin/shutdown.sh
</code>
==Tomcat Auto Start einrichten ==
Datei unter /etc/systemd/sys... Rollen benötigt.
* manager-gui - allows access to the HTML GUI and the status pages
* manager-script - allows access to the text interface and the status pages
* manager-jmx - allows access to the JMX proxy and the status pages
* manager-st
nbank Home setzen!
chopt enable ode_net
Writing to C:/oracle/products/12.1.0.2/dbhome_1/install/enab... en ===
Normalerweise:
<code>
ORA-28575 - unable to open RPC connection to external procedure agent
Cause: tnsnames.ora and listener.ora files have not been correctly configured to use external procedures.
</code>
Auf das richt
tei:
<code plsql>
..
select count(ID)
into v_file_count
from apex_application_temp_f... p_files
select blob_content
into v_blob_data
from apex_application_temp... d [[ http://oraexplorer.blogspot.com/2007/11/apex-to-upload-text-file-and-write-into.html | Ittichai ]].
Ziel ist es eine beliebige CSV Tabelle in eine
oduced in HTTP/2, have been moved outside of HTTP to the new lower transport protocol called QUIC.
..
... the use of HTTP cookies
: - switch to backup servers in the event a main one fails
: - accept connections to special ports dedicated to service monitoring
: - stop accepting connections without br
https://www.thatjeffsmith.com/archive/2018/12/how-to-export-your-restful-services/
=== SQLcl ===
Dow... sql / as sysdba
help rest
REST
------
Use REST to export/import modules or list objects from Oracle... _prefix> - Export a specific module related to the given prefix
REST modules ... Services - Interactive Install
Enter a number to select the type of installation
[1] Install o
uota unlimited on USERS;
grant connect, resource to conbook;
-- create the info Archive DIRECTORY
c... mages';
grant read,write on directory IMG_ARCHIVE to conbook;
</code>
Darauf achten das der Oracle Us... return a referenz on the img object
insert into CON_IMAGES (ID, NAME, REMARKS,img,preview)
... e(),ORDSYS.ORDImage.init())
RETURNING img INTO v_img_orig;
-- read the image data to t
Leider steht keine interne Default Funktion wie to_char zur Verfügung einen Long Value direkt in cha... es in PL/SQL zwei Funktionen zur Verfügung, CAST_TO_VARCHAR2 und CAST_TO_RAW.
==== Einfachste Version einer Hilfsfunktion zum Auslesen von EBDIC bzw ei... s Ganze nun als RAW Wert
sql>select utl_raw.cast_to_raw(CONVERT('Kostenübernahme','WE8ISO8859P15','WE
xcept for Oracle Database Express Edition) solely to support connectivity to Oracle Application Express, which may be installed in the Oracle Database. Ru... ver does not require that that server be licensed to use the Oracle Database."//
siehe => http://docs... line.ModifyConfigDir execute
INFO: Set config.dir to D:\srv\ords in: D:\oracle\product\ords.3.0.4\ords
v_start number;
begin
select nvl(max(id),0) into v_start from gpi.col_t;
for i in v_start..100000
loop
insert into gpi.col_t (id ,a1, a2, a3, a4)
values ( i
... o --
Info -- Count of blocks that has at least 0 to 25% free space :0 |Bytes :0
Info -- Count of blocks that has at least 25 to 50% free space :1 |Bytes :8192
Info -- Count of
Rollen benötigt
* manager-gui - allows access to the HTML GUI and the status pages
* manager-script - allows access to the text interface and the status pages
* manager-jmx - allows access to the JMX proxy and the status pages
* manager-status - allows access to the status pages only
<code xml>
<role rolename