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