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
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
)
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
ba
SELECT NAME, OPEN_MODE, RESTRICTED, OPEN_TIME FROM V$PDBS;
# Root container über den Service anmel... ba
SELECT NAME, OPEN_MODE, RESTRICTED, OPEN_TIME FROM V$PDBS;
--Plugable starten
ALTER PLUGGABLE DAT
can be
installed and used on a machine different from the machine where the Oracle Database is installe... Changed database context to 'ORATST'.
1> select * from dual;
2> go
FROM_X
--------------------------------------------------
(0 rows affected)
1> insert into dual (from_x) values ("X");
2> go
(1 rows affected)
1> sel
agen
SELECT credential_name
,username
FROM user_credentials
ORDER BY credential_name
/
<... , actual_start_date
, additional_info
FROM user_scheduler_job_run_details
WHERE job_name='E... und BINARY_OUTPUT) :
<code sql>
select OUTPUT from user_scheduler_job_run_details WHERE job_name = '... n
select utl_raw.cast_to_varchar2(BINARY_OUTPUT) from user_scheduler_job_run_details WHERE job_name = '