1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| select * from sys.v_$version;
BANNER
----------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
create table t_virtual_null
( ID_REF_FREQ_INT_AN VARCHAR2(10) DEFAULT 'FREQ_INT'
, FREQ_INT_AN VARCHAR2(10)
, NBR_FREQ_AN AS (TO_NUMBER(FREQ_INT_AN))
);
-- Table created.
insert into t_virtual_null (FREQ_INT_AN) values ('123');
-- 1 row(s) inserted.
insert into t_virtual_null (FREQ_INT_AN) values (null);
-- 1 row(s) inserted. |
Partager