g und kann es verwendet werden ===
<code plsql>
set serveroutput on
declare
v_out1 varchar2(3000);
... cht ausreichend:
<code bash>
SP2-0158: Unbekannte SET-Option "show"
Zeile 676: "set SQLC MIX" ist veraltet.
SP2-0158: Unbekannte SET-Option "recsep"
Autotrace deaktiviert
</code>
----
ivate/haproxy.pem
mode http
http-request set-header X-Forwarded-For %[src]
reqadd X-Forwar... y default, if your workload permits it you should set it to at least 2048. Please set a value >= 1024 to make this warning disappear.
Configuration file is... t name, for mod_proxy ensure ProxyPreserveHost is set to On
</code>
siehe dazu auch den Oracle Suppor
xpand_sql_text die Funktion auflösen kann:
<code>
SET SERVEROUTPUT ON
DECLARE
v_full_sql CLOB;
BEGIN... keinen Sinn ...
-- nächster Versuch:
with data_set as (
select k.Kundenname,
getInteralKDNrSQM... teralKDNr
from Kunden k
)
select *
from data_set
group by Kundenname
, InteralKDNr
SQL... über **DBMS_UTILITY.expand_sql_text**
<code sql>
SET SERVEROUTPUT ON
DECLARE
v_full_sql CLOB;
BEGIN
h>
timedatectl
#falls es nicht passt
timedatectl set-timezone Europe/Berlin
</code>
Für die eigentli... space für APEX anlegen:
<code sql>
ALTER SESSION SET CONTAINER = ans;
CREATE TABLESPACE APEX DATAFIL... RESTRICTED, OPEN_TIME FROM V$PDBS;
ALTER SESSION SET CONTAINER = FREE;
SHOW CON_NAME
</code>
=== ... iner wechseln
sqlplus / as sysdba
ALTER SESSION SET CONTAINER = FREEDB1;
#prüfen ob nicht ein alter
e [1]: 2
The setting named: db.connectionType was set to: basic in configuration: default
The setting named: db.hostname was set to: 10.10.10.90 in configuration: default
The setting named: db.port was set to: 1521 in configuration: default
The setting named: db.servicename was set to: SRV_GPIDB_MAIN in configuration: default
The
L_STORE', 'multi_column_datastore' )
exec ctx_ddl.set_attribute ( 'GPI_MULTI_COL_STORE', 'columns', 'kd_name, anschrift, bemerkung' )
exec ctx_ddl.set_attribute ( 'GPI_MULTI_COL_STORE', 'filter', ... n t1
for each row
begin
update search_master set CHANGE_DATE=to_char(sysdate) where PK_TABLENAME='... n t2
for each row
begin
update search_master set CHANGE_DATE=to_char(sysdate) where PK_TABLENAME='
-----------------------------------------
-- Set Apex Workspace ID and Security Group ID
SELEC... FROM dual);
apex_util.set_security_group_id(p_security_group_id => v_worksp... die Tabelle direkt gelöscht werden.
<code plsql>
set serveroutput on
set serveroutput on
declare
-- ========================================
-- APEX Ma
OME/bin
./ords --config /srv/ords/config/ config set --global instance.api.enabled true
ORDS: Release... he global setting named: instance.api.enabled was set to: true
</code>
Mit dem Kommando wird der Wer
-- put in your workspace
apex_util.set_security_group_id (p_security_group_id => apex_ut... END IF;
$END
END;
/
--- testen
set serveroutput on
begin
dbms_output.put_line('-- In... EX - Package variable g_security_group_id must be set ====
Fehler:
<code sql>
ORA-20987: APEX - Package variable g_security_group_id must be set. - Contact your application administrator.
</code
QL Script um die Daten zu ermittlen:
<code sql>
set long 2000000;
set pagesize 0
set linesize 2300
set heading off
set echo off
set feedback off
-- define the name of the spoolfile
set t
ecken
<code dos>
cd <LAUFWERK>
cd <PROJKET_DIR>
set GIT_HOME=C:\Program Files\Git
"%GIT_HOME%\cmd\gi... code>
Bzw. in der Powershell
<code powershell>
set-item -path env:GIT_HOME -value "C:\Program Files\... ecken:
<code dos>
cd <LAUFWERK>
cd <PROJKET_DIR>
set GIT_HOME=C:\Program Files\Git
"%GIT_HOME%\cmd\gi