miércoles, 29 de abril de 2020

CREATE TABLE PERIOD FOR USER_TIME

CREATE TABLE HR.prueba2 (
empno NUMBER(6) NOT NULL
,ename VARCHAR2(20),
PERIOD FOR user_time);
SELECT column_name
,data_type
,column_id AS col_id
,segment_column_id AS seg_col_id
,internal_column_id AS int_col_id
,hidden_column
,virtual_column
FROM user_tab_cols WHERE table_name = ‘PRUEBA2’;

SQL> desc hr.prueba2;
 Name    Null?    Type
 ----------------------------------------- -------- ----------------------------
 EMPNO    NOT NULL NUMBER(6)
 ENAME     VARCHAR2(20)

SQL> 

No hay comentarios: