r über die Umgebung anmelden
sqlplus / as sysdba
SELECT NAME, OPEN_MODE, RESTRICTED, OPEN_TIME FROM V$PDB... atisch starten:
<code sql>
sqlplus / as sysdba
SELECT NAME, OPEN_MODE, RESTRICTED, OPEN_TIME FROM V$PDB
<code sql>
insert into JSON_EMP (empno,emp_value)
select empno
,'{'
||' "EMPNO":"'||EMPNO||'"'
||' ... te direkt in SQL referenziert werden:
<code sql>
SELECT j.emp_value.ENAME, j.emp_value.DEPTNO FROM JSON_E... kann das Escapen verhindert werden.
<code sql>
select json_object ( ....
, KEY 'Contact' is ob.j
Längen nach Anlage der Tabelle mit:
<code sql>
SELECT col.TABLE_NAME
, col.COLUMN_NAME
,... -----------
A VARCHAR2(10)
SQL>select data_type,data_length from user_tab_columns where... -----------
A VARCHAR2(10)
SQL>select data_type,data_length from user_tab_columns where... veroutput ON
DECLARE
cursor c_char_cols
IS
SELECT col.TABLE_NAME
,col.COLUMN_NAME
,co
GPIPPERR"
GPIPPERR@CMAN2_GPIDB23c-oracledb23c01>SELECT SYS_CONTEXT('USERENV','PROXY_USER') FROM dual;
S...
CMAN_TDM
GPIPPERR@CMAN2_GPIDB23c-oracledb23c01>SELECT SYS_CONTEXT('USERENV','IP_ADDRESS') FROM dual;
S... s "HR"
HR@//localhost:1521/freedb1-oracledb23c01>SELECT SYS_CONTEXT('USERENV','PROXY_USER') FROM dual;
S... ser
USER is "HR"
HR@CMAN2_GPIDB23c-oracledb23c01>SELECT SYS_CONTEXT('USERENV','PROXY_USER') FROM dual;
S
l_db
# mit dem Password von GPI anmelden:
SQL>select user from dual;
USER
-----
HR
</code>
==== Übe... darf sich an diesem Schema anmelden:
<code sql>
select proxy
, client
, authentication
, authorizati... arf sich an welches Schema anmelden:
<code sql>
select proxy
, client
, authentication
, authorizati... rage der Umgebung der SQL Session mit:
<code sql>
SELECT SYS_CONTEXT ('USERENV', 'CURRENT_USER')
r über die Umgebung anmelden
sqlplus / as sysdba
SELECT NAME, OPEN_MODE, RESTRICTED, OPEN_TIME FROM V$PDB... atisch starten:
<code sql>
sqlplus / as sysdba
SELECT NAME, OPEN_MODE, RESTRICTED, OPEN_TIME FROM V$PDB
st
2> go
Changed database context to 'ORATST'.
1> select * from dual;
2> go
FROM_X
-----------------------... rom_x) values ("X");
2> go
(1 rows affected)
1> select * from dual;
2> go
FROM_X
-----------------------... ST
2> go
Changed database context to 'ORATST'.
1> select * from dual;
2> go
FROM_X
-----------------------... ------------------------
X
(1 rows affected)
1> SELECT NAME FROM sys.sysdatabases;
2> go
1> exit
</co