The following have been found in Oracle scripts and are representatives of a class of built-in constants

wmsys.lt.optimistic_locking
wmsys.wm_error.raiseerror(wmsys.lt.wm_error_172_no);
wmsys.wm_error.raiseerror(wmsys.lt.wm_error_192_no, err_msg);
wmsys.wm_error.raiseerror(wmsys.lt.wm_error_195_no, err_msg_full);

conn scott/tiger

GRANT select ON dept TO ltdemo;
GRANT select ON emp TO ltdemo;

conn ltdemo/ltdemo

CREATE TABLE dept AS
SELECT * FROM scott.dept;

ALTER TABLE dept
ADD CONSTRAINT pk_dept
PRIMARY KEY (deptno)
USING INDEX
PCTFREE 0;

CREATE TABLE emp AS
SELECT * FROM scott.emp;

ALTER TABLE emp
ADD CONSTRAINT pk_emp
PRIMARY KEY (empno)
USING INDEX
PCTFREE 0;

ALTER TABLE emp
ADD CONSTRAINT fk_emp_deptno
FOREIGN KEY (deptno)
REFERENCES dept(deptno);

ALTER TABLE emp
ADD CONSTRAINT fk_emp_emp
FOREIGN KEY (mgr)
REFERENCES emp(empno);

col object_name format a30

SELECT object_name, object_type
FROM user_objects;

SELECT table_name, constraint_name, constraint_type
FROM user_constraints;

SELECT * FROM dept;

SELECT * FROM emp;

set serveroutput on

exec whereami

SELECT dbms_wm.GetLockMode FROM dual;

SELECT dbms_wm.GetPrivs('ws1') FROM dual;

SELECT dbms_wm.GetPrivs('ws2') FROM dual;

SELECT dbms_wm.GetSystemParameter('ALLOW_CAPTURE_EVENTS')
FROM dual;

SELECT dbms_wm.IsWorkspaceOccupied('ws1')
FROM dual;

SELECT dbms_wm.IsWorkspaceOccupied('ws2')
FROM dual;

exec dbms_wm.GotoWorkspace('LIVE');

exec dbms_wm.MergeWorkspace('ws2');

SELECT ename, sal, comm
FROM emp;