***Use case code sample.
CREATE TABLE eye (
ID NUMBER(*,0) GENERATED ALWAYS AS IDENTITY MINVALUE 1 MAXVALUE 999 INCREMENT BY 1
START WITH 1 CACHE 20 NOORDER NOCYCLE NOKEEP NOSCALE NOT NULL ENABLE,
NBR NUMBER NOT NULL ENABLE,
STRING VARCHAR2(128 CHAR) NOT NULL ENABLE,
TIME_STAMP TIMESTAMP NOT NULL ENABLE,
TIME_STAMP_TZ TIMESTAMP WITH TIME ZONE NOT NULL ENABLE,
TIME_STAMP_LTZ TIMESTAMP WITH LOCAL TIME ZONE NOT NULL ENABLE,
DATETIME DATE NOT NULL ENABLE,
BOOL BOOLEAN NOT NULL ENABLE,
BINARY_DOUBLE BINARY_DOUBLE NOT NULL ENABLE,
BINARY_FLOAT BINARY_FLOAT NOT NULL ENABLE,
INTERVAL_DS INTERVAL DAY TO SECOND NOT NULL ENABLE,
INTERVAL_YM INTERVAL YEAR TO MONTH NOT NULL ENABLE );
INSERT INTO eye( NBR, STRING,
TIME_STAMP, TIME_STAMP_TZ, TIME_STAMP_LTZ,
DATETIME, BOOL, BINARY_DOUBLE, BINARY_FLOAT,
INTERVAL_DS, INTERVAL_YM )
VALUES (303, 'STRING',
TO_TIMESTAMP(sysdate),
timestamp '2025-01-01 00:00:00 +00:00',
cast(from_tz(timestamp '2025-12-31 23:59:59','UTC') as timestamp with local time zone),
SYSDATE,
TRUE,
876.5018236,
323.23234,
interval '2' day,
interval '1' year );
COMMIT;
*** For each column data type (except NBR), click the eye to open the "UI control".
*** You can interact with the data type UI control, but cannot save the adjusted value!
select * from eye for UPDATE; --Should be able to change values, right?
*** Execute each query then click/select the data and click the eye.
*** Values which ARE NOT table columns cannot be adjusted!
*** eye UI controls are n/a. Copy to clipboard seemingly is the only logical option.
select TO_TIMESTAMP(sysdate) from dual;
select interval '2' day from dual;
select interval '1' year from dual;
select cast(from_tz(timestamp '2025-12-31 23:59:59','UTC') as timestamp with local time zone) from dual;
select 'STRING' from dual;
select timestamp '2025-01-01 00:00:00 +00:00' from dual;
*** number types: no eye, how it should be!
select 303 from dual;
select CAST(876.5018236 AS FLOAT) from dual;
select TO_CHAR(sysdate,'DD-MON-YY') from dual;
*** click eye, right-click, select Copy, then paste. Not what I expect to happen
All rows fetched: 1 in 0.027 seconds
Press SPACE to select this row.
30-JUL-25