CREATE TABLE HR.prueba2 (
empno NUMBER(6) NOT NULL
,ename VARCHAR2(20),
PERIOD FOR user_time);
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’;
Name Null? Type
----------------------------------------- -------- ----------------------------
EMPNO NOT NULL NUMBER(6)
ENAME VARCHAR2(20)
SQL>
No hay comentarios:
Publicar un comentario