erzielen.
**Typen:**
- Funktion kann in der From Klausel verwendet werden (Table SQL Macro) - Para...
</code>
Aufrufen:
<code sql>
select customerId from dual;
customerId
---
42
</code>
Was für ein S... ext (
input_sql_text => q'[select customerId from dual ]',
output_sql_text => v_full_sql
);
... ;
/
---
SELECT "GPI"."CUSTOMERID"() "CUSTOMERID" FROM "SYS"."DUAL" "A1" WHERE "GPI"."CUSTOMERID"()=101
Syntax:
<code sql>
SELECT id
, SCORE(1)
FROM TEXTE
WHERE CONTAINS(column, 'query_string',1)>0... r Gruppierung
wie:
SELECT id
, SCORE(1)
FROM TEXTE
WHERE CONTAINS(column, 'DEFINESCORE(query_... -------------
-- check for errors
SELECT count(*) FROM ctx_user_index_errors
/
</code>
Unsere Daten se... m Wort in allen Texten:
<code sql>
select id,text from texte where contains(text, 'Hund')>0
</code>
Erg
P' )
/
--Check for any filtering errors
select * from ctx_user_index_errors;
</code>
Suchen:
<code sql>
select kd_id from kunden where contains(bemerkung,'Ziegel') > 0;
kd_id
------
1
4
</code>
<code sql>
select * from kunden where contains(bemerkung,'Ziegel within kd... ME,CHANGE_DATE)
select null,t1_id, 'T1' , sysdate from t1
;
insert into search_master ( search_id,PK_ID
DB auf den richtigen Container achten!
select * from DBA_REGISTRY WHERE COMP_ID = 'APEX';
Oracle App... #Patch Stand:
select patch_version, installed_on from apex_patches;
PATCH_VERSION INS... Use REST to export/import modules or list objects from Oracle REST Data Services.
REST exp... ervices 22.2.1.r2021302
Type : ORDS Upgrade from 20.4.3.r0501904 to 22.2.1.r2021302
Database : O
ner
,directory_name
,directory_path
from dba_directories
order by 1
,2
/
</code>... ate,'dd.mm.yyyy hh24:mi')
, current_scn
from v$database
/
NAME TO_CHAR(SYSDATE, CURRE...
select owner
,obj_type
,obj_count
from (
select count(*) as obj_count, object_type as obj_type, owner
from dba_objects
group by object_type,owner
)
eleted</del> as well.
**Paragraphs** are created from blank lines. If you want to **force a newline** w... the section name behind a hash character as known from HTML. This links to [[syntax#internal|this Sectio... x|existing pages]] are shown in a different style from [[nonexisting]] ones.
* DokuWiki does not use [... ]].
There are three exceptions which do not come from that pattern file: multiplication entity (640x480
meiner DB aktuell eingestellt:
* SELECT value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET';“
Wa... werden unterstützt:
* Über das DD => "select * from V$NLS_VALID_VALUES“;
* Über die Doku 12c => ht... den:
<code sql>
select username,oracle_maintained from dba_users;
</code>
* [[dba:kill_session_witho... herit the ulimit setting for "max user processes" from /etc/security/limits.conf setting (Doc ID 1594606
dem Password von GPI anmelden:
SQL>select user from dual;
USER
-----
HR
</code>
==== Überwachen mi... horization_constraint
, role
, proxy_authority
from dba_proxies
where client like upper('&&SCHEMA_NAM... horization_constraint
, role
, proxy_authority
from dba_proxies
where proxy like upper('&&USER_NAME.'... ('USERENV', 'AUTHENTICATED_IDENTITY') AUTH_IDENT
FROM DUAL
/
</code>
siehe [[http://docs.oracle.com/cd
tenbanken
SHOW DATABASES;
#User
SELECT Host,User FROM mysql.user;
#Unötige entfernen
DELETE FROM mysql.user WHERE Host='::1' AND User='root'
quit
#LOG-Rot... viliges are reloaded.
FLUSH PRIVILEGES;
SELECT * FROM mysql.user WHERE User = 'guacamole_user';
SHOW G... etContextListener - Read configuration parameters from "/etc/guacamole/guacamole.properties".
11:55:13.5
E;
SELECT NAME, OPEN_MODE, RESTRICTED, OPEN_TIME FROM V$PDBS;
ALTER SESSION SET CONTAINER = FREE;
SH... ow if you want
# to redirect traffic to ORDS from root path
# RedirectMatch permanent "^/$" "/o... cht ein alter APEX Stand exisiert
select username from dba_users;
#falls ja mit @apxremov aus dem Oracle... NER = FREEDB1;
select patch_version, installed_on from apex_patches;
</code>
Statische Dateien kopiere
gth semantics (B) or CHAR length semantics (C),
FROM user_tab_columns col
--show only tables no ... VARCHAR2(10)
SQL>select data_type,data_length from user_tab_columns where table_name ='GT';
DATA_T... VARCHAR2(10)
SQL>select data_type,data_length from user_tab_columns where table_name ='GT';
DATA_T... gth semantics (B) or CHAR length semantics (C),
FROM user_tab_columns col
--show only tables no
OMM||'"'
||' ,"DEPTNO":"'||DEPTNO||'"'
||'}'
from emp
/
commit;
</code>
=== In den Daten nun suc... sql>
SELECT j.emp_value.ENAME, j.emp_value.DEPTNO FROM JSON_EMP j;
</code>
Auf die GROSS/klein Schreibun... s ob.json_rec format json
..
returning clob
)
from table_with_json_records;
</code>
<note tip>Ac