N'
) ;
CREATE UNIQUE INDEX IDX_Documents_ID_PK ON Documents ( ID ASC );
ALTER TABLE Documents ADD... STRAINT Document_PK 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
\info-archiv';
#Rechte vergeben
grant read,write on directory INFO_ARCHIVE to GPI;
</code>
=== Doku... N'
) ;
CREATE UNIQUE INDEX IDX_Documents_ID_PK ON Documents ( ID ASC );
ALTER TABLE Documents ADD... STRAINT Document_PK PRIMARY KEY ( ID ) ;
COMMENT ON TABLE Documents IS 'Store the file information' ;
COMMENT ON COLUMN Documents.ID IS 'Primary Key' ;
COMMENT O
//www.linuxtechi.com/create-extend-xfs-filesystem-on-lvm/
----
==== Datenbank ====
Im ersten Schritt... DB Software ===
Aktuell ist nur die FREE Edition on-premise verfügbar siehe dazu => [[dba:oracle_23c_... adata/FREE/FREEDB1/apex01.dbf' SIZE 1G AUTOEXTEND ON NEXT 500K MAXSIZE 4G;
</code>
Plugable starte... rverAlias apex01.pipperr.local
RewriteEngine on
RewriteCond %{SERVER_NAME} =apex01.pipperr.lo
ist es einen Oracle Apex Umgebung mit Single Sign on unter Windows zu betreiben.
Eingesetzt werden so... ichten
* Apache HTTP einrichten
* Single Sign on konfigurieren
In den folgenden Kommandozeilen ... _v01.png | Oracle ORDS mit Apache und Single Sign On}}
----
==== Download der notwendigen Software...
<code apache>
##### use only SSL
RewriteEngine On
RewriteCond %{SERVER_PORT} !=443
RewriteRule (.*)
der eingesetzte Webserver prüfen.
===Single Sign On unter Windows 2012 mit Apache HTTP und dem NTLM M... [prog:oracle_rest_data_service_tomcat#single_sign_on_mit_dem_apache_einrichten|Oracle ORDS 3.0 (Oracle... Apache Application Server Tomcat für Single Sign On unter Windows 2012 betreiben]]
Über das Modul wi... nur der Windows User Name wird an die Single Sign On Konfiguration von Apex für die jeweilige Applikat
blespace TEMP;
alter user conbook quota unlimited on USERS;
grant connect, resource to conbook;
-- ... ork\OracleMultiMedia\99-Images';
grant read,write on directory IMG_ARCHIVE to conbook;
</code>
Darauf... BEGIN
-- save metadata and return a referenz on the img object
insert into CON_IMAGES (ID, NA... ql>
delete CON_IMAGES;
commit;
set serveroutput on
begin
for i in 1 .. 13
loop
loadCo
varchar2(256));
create unique index idx_vertex_pk on vertex(name);
create table edge ( edge_id number... varchar2(256));
create unique index idx_edge_pk on edge(edge_id);
create sequence seq_edge;
insert ... l gestartet werden und mit dem Setting "pgql auto on" wird der PGQL Modus aktiviert.
<code sql>
H:\tools\sqlcl\bin\sql.exe GPI@GPIDB
pgql auto on
PGQL Auto enabled for graph=[null], execute=[tru
ndex idx_kunden_ctx;
create index idx_kunden_ctx on kunden( bemerkung )
indextype is ctxsys.context
f... (
search_id number(11) GENERATED BY DEFAULT ON NULL AS IDENTITY
, PK_ID number(11)
, PK_TABLEN... reate or replace trigger t1_i_trg
after insert
on t1
for each row
begin
insert into search_mast... reate or replace trigger t1_u_trg
after update
on t1
for each row
begin
update search_master s
ER | FULL OUTER | NATURAL | CROSS ] JOIN Tab2
ON T1.id = T2.id
where
tab1.filter = filter_bed... oin Typen ====
===Inner Join = Equivalent Join - on () ===
Verbindet Datensätze aus zwei Tabellen, s... ECT * FROM EMPLOYEES e INNER JOIN DEPARTMENTS d ON e.DEPARTMENT_ID = d.DEPARTMENT_ID
</code>
SQL 8... ount(*) from EMPLOYEES e inner join DEPARTMENTS d on ( NVL(e.DEPARTMENT_ID,-1) = to_number(d.DEPARTMEN
ieren und aufrufen:
<code plsql>
set serveroutput on
declare
wrong_value exception;
pragma excep... N ORA-06511 Cursor bereits geöffnet
* DUP_VAL_ON_INDEX ORA-00001 Schlüssel doppelt eingetrage... 1403 SELECT liefert kein Ergebnis
* NOT_LOGGED_ON ORA-01012 Keine Verbindung zur Datenbank
... OR ORA-06500 Speicherprobleme
* TIMEOUT_ON_RESOURCE ORA-00051 Datenbank-Sperre
* TOO_MAN
86_64
Last metadata expiration check: 0:06:00 ago on Wed 06 Mar 2024 11:57:16 CET.
Available Packages
... :
: - route HTTP requests depending on statically assigned cookies
: - spr... for mod_proxy ensure ProxyPreserveHost is set to On
</code>
siehe dazu auch den Oracle Support Arti... xy
group haproxy
daemon
# turn on stats unix socket
stats socket /var/lib/hapro
ff
SET heading off
set termout off
set markup CSV ON
spool import_to_excel.csv
select to_char(datum,... desc
/
spool off
set markup CSV OFF
set termout ON
SET feedback ON
SET heading ON
SET echo ON
SET verify ON
</code>
In Excel eine Bereich der Daten visualisieren:
{
able T as select * from all_objects;
grant select on T to B;
select count(*) from b.v_t;
COUNT(*)
-... select * from A.t where owner='SYS';
grant select on v_t to c;
ERROR at line 1:
ORA-01720: grant opti... oes not exist for 'A.T'
connect a/A
grant select on T to B with grant option;
connect b/B
grant select on v_t to c;
</code>
User C:
<code sql>
connect c/C