mounten
ALTER PLUGGABLE DATABASE ans SAVE STATE;
SELECT NAME, OPEN_MODE, RESTRICTED, OPEN_TIME FROM V$PDB...
#prüfen ob nicht ein alter APEX Stand exisiert
select username from dba_users;
#falls ja mit @apxremov ... as sysdba
ALTER SESSION SET CONTAINER = FREEDB1;
select patch_version, installed_on from apex_patches;
<... rvices - Interactive Install
Enter a number to select the type of installation
[1] Install or upgra
Container DB auf den richtigen Container achten!
select * from DBA_REGISTRY WHERE COMP_ID = 'APEX';
Ora... ication Express
20.2.0.00.20
#Patch Stand:
select patch_version, installed_on from apex_patches;
P... rvices - Interactive Install
Enter a number to select the type of installation
[1] Install or upgra... ase pool only
Choose [2]: 2
Enter a number to select the database connection type to use
[1] Basic
>
Oder über die View DBA_REGISTRY:
<code sql>
select * from DBA_REGISTRY WHERE COMP_ID = 'APEX';
APEX...
select patch_version, installed_on from apex_patches;
E... es not exist
# kann vor 21 ignoriert werden
SQL> select patch_version, installed_on from apex_patches;
P
200 | Oracle Text Katze V3}}
Syntax:
<code sql>
SELECT id
, SCORE(1)
FROM TEXTE
WHERE CONTAINS(... S und Rechenoperationen () für Gruppierung
wie:
SELECT id
, SCORE(1)
FROM TEXTE
WHERE CONTAINS(... ction')
/
------------------
-- check for errors
SELECT count(*) FROM ctx_user_index_errors
/
</code>
U...
Suche nach dem Wort in allen Texten:
<code sql>
select id,text from texte where contains(text, 'Hund')>0
or c_news_letter_images(p_app_id number)
is
select replace(filename,'newsletter_images/','') as file... c_get_attachment(p_file_id number)
is
select f.FILENAME
, f.MIMETYPE
, f... or c_news_letter_images(p_app_id number)
is
select replace(filename,'newsletter_gpi/','') as filenam... c_get_attachment(p_file_id number)
is
SELECT f.FILENAME
, f.MIMETYPE
, f
ostet 1.10 Euro beim gp@tester.de' **
<code sql>
select regexp_substr('Der Kohl kostet 1.10 Euro beim gp@... enwerte der Telefon Nr. zu erhalten.
<code sql>
select regexp_replace('+45 987 789.78989 nur nachmittags... bis 3 Zeichen noch belassen, rest weg:
<code sql>
select regexp_substr ('10.3088888', '[[:digit:]]+[.][[... ing ==
Zählen alle ; in diesem String
<code sql>
select REGEXP_COUNT('1;2;3;4;5;6',';') from dual;
----
5
_val SPOOL_NAME
column SPOOL_NAME_COL format a60
select SYS_CONTEXT('USERENV', 'HOST')||'_'||global_name... on
DECLARE
cursor c_orauser_schemas
is
select username
from dba_users
where ORACLE_MAINTAINED ='Y'
union
select 'PUBLIC' from dual
order by 1;
v_handle ... Meta Data
-- Use dbms_xmlgen to get result of select in XML Format
--
v_result:=v_result||'<DBDB
sein, sonst funktioniert es gar nicht.
<code sql>
SELECT * FROM sys.RESOURCE_IO_CALIBRATE$
</code>
sie...
Ab 12 sind Default Werte hinterlegt:
<code sql>
select OPERATION_NAME, DEFAULT_VALUE
from V$OPTIMIZER_P... arallel in meiner Session aktiv sind:
<code sql>
select name, value from v$ses_optimizer_env
where name... egree_limit','parallel_max_degree')
and sid=(select sid from v$mystat where rownum=1);
parallel_d