Getting Information on View Definitions with DESCRIBE command

 
CREATE TABLE EMP (EMPNO NUMBER(4) NOT NULL,
                  ENAME VARCHAR2(10),
                  JOB VARCHAR2(9),
                  SAL NUMBER(7, 2),
                  DEPTNO NUMBER(2));
                  
CREATE VIEW emp_view AS
SELECT *
FROM emp
WHERE sal < 1500
WITH READ ONLY CONSTRAINT emp_read_only;

SQL> DESCRIBE emp_view
 Name                                      Null?    Type
 ----------------------------------------- -------- --------------------
 EMPNO                                     NOT NULL NUMBER(4)
 ENAME                                              VARCHAR2(10)
 JOB                                                VARCHAR2(9)
 SAL                                                NUMBER(7,2)
 DEPTNO                                             NUMBER(2)

SQL>