select * from ALL_OBJECTS where OBJECT_NAME = 'OBJECT_NAME';
Get DDL
SELECT DBMS_METADATA.GET_DDL('OBJECT_TYPE','OBJECT_NAME'[,'OWNER']) FROM DUAL;
--
select dbms_metadata.get_ddl('TABLE', o.OBJECT_NAME),';'
from user_objects o
where OBJECT_TYPE='TABLE' and o.OBJECT_NAME in ('TABLE_NAME');
Tables referenced to the current
select * from user_constraints where CONSTRAINT_NAME='SYS_C00365462';
--
select fk.TABLE_NAME, fk.CONSTRAINT_NAME, fk.CONSTRAINT_TYPE, fk.R_CONSTRAINT_NAME, cc.COLUMN_NAME
from user_constraints fk
inner join user_constraints pk on pk.CONSTRAINT_TYPE='P'
and pk.TABLE_NAME='COUNTRY'
and pk.CONSTRAINT_NAME=fk.R_CONSTRAINT_NAME
inner join user_cons_columns cc on cc.TABLE_NAME=fk.TABLE_NAME
and cc.CONSTRAINT_NAME=fk.CONSTRAINT_NAME
where fk.CONSTRAINT_TYPE='R'
order by fk.TABLE_NAME;
Running quires
select t.FIRST_LOAD_TIME, t.* from gv$sql t
where t.SQL_TEXT like 'UPDATE T%'
order by t.FIRST_LOAD_TIME desc;
--
SELECT * FROM v$sql_bind_capture
where SQL_ID in ('bcz2c14ut3hyb');
Date format
SELECT value FROM v$nls_parameters WHERE parameter ='NLS_DATE_FORMAT';
Partitions
ALTER TABLE table_1 ADD PARTITION COUNTRY_1 VALUES (1) TABLESPACE TS_1;
Kill session
select sid,serial# from v$session where username = 'username';
alter system kill session '101,12345';
DDL WAIT
ALTER SESSION SET DDL_LOCK_TIMEOUT = 100;
SQL Developer
Config in ~\AppData\Roaming\Oracle SQL Developer Data Modeler\4.0.2.840\product.conf (AddVMOption)