Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table parent(
id int primary key);
create table child(
id int ,
constraint fk_id foreign key (id) 
references parent(id));
select * from all_constraints
where table_name = 'CHILD'
or table_name = 'PARENT'


OWNER
CONSTRAINT_NAME
CONSTRAINT_TYPE
TABLE_NAME
SEARCH_CONDITION
SEARCH_CONDITION_VC
R_OWNER
R_CONSTRAINT_NAME
DELETE_RULE
STATUS
DEFERRABLE
DEFERRED
VALIDATED
GENERATED
BAD
RELY
LAST_CHANGE
INDEX_OWNER
INDEX_NAME
INVALID
VIEW_RELATED
ORIGIN_CON_ID


FIDDLE_QTJFUOSPEOESJJQZMQTE
SYS_C0070722
P
PARENT
null
null
null
null
null
ENABLED
NOT DEFERRABLE
IMMEDIATE
VALIDATED
GENERATED NAME
null
null
19-APR-23
FIDDLE_QTJFUOSPEOESJJQZMQTE
SYS_C0070722
null
null
3

FIDDLE_QTJFUOSPEOESJJQZMQTE
FK_ID
R
CHILD
null
null
FIDDLE_QTJFUOSPEOESJJQZMQTE
SYS_C0070722
NO ACTION
ENABLED
NOT DEFERRABLE
IMMEDIATE
VALIDATED
USER NAME
null
null
19-APR-23
null
null
null
null
3

OWNER	CONSTRAINT_NAME	CONSTRAINT_TYPE	TABLE_NAME	SEARCH_CONDITION	SEARCH_CONDITION_VC	R_OWNER	R_CONSTRAINT_NAME	DELETE_RULE	STATUS	DEFERRABLE	DEFERRED	VALIDATED	GENERATED	BAD	RELY	LAST_CHANGE	INDEX_OWNER	INDEX_NAME	INVALID	VIEW_RELATED	ORIGIN_CON_ID
FIDDLE_QTJFUOSPEOESJJQZMQTE	SYS_C0070722	P	PARENT	null	null	null	null	null	ENABLED	NOT DEFERRABLE	IMMEDIATE	VALIDATED	GENERATED NAME	null	null	19-APR-23	FIDDLE_QTJFUOSPEOESJJQZMQTE	SYS_C0070722	null	null	3
FIDDLE_QTJFUOSPEOESJJQZMQTE	FK_ID	R	CHILD	null	null	FIDDLE_QTJFUOSPEOESJJQZMQTE	SYS_C0070722	NO ACTION	ENABLED	NOT DEFERRABLE	IMMEDIATE	VALIDATED	USER NAME	null	null	19-APR-23	null	null	null	null	3