Oracle - consulta de objetos

alguien sabe como hacer esto en Oracle

sql server
Select
count (sc.name)
from
sysobjects so, syscolumns sc
where
sc.id = so.id
AND so.name = 'CONTRATOS'
AND so.xtype = 'V'
AND (
sc.name = 'apellido_paterno'
or sc.name = 'apellido_materno'
or sc.name = 'nombre'
or sc.name = 'cve_empleado'
)
intente esto, pero no me arroja lo mismo

Select
count (column_name)
from
user_tab_columns
where
table_name = 'CONTRATOS'
AND (
column_name = 'apellido_paterno'
or column_name = 'apellido_materno'
or column_name = 'nombre'
or column_name = 'cve_empleado'
)

Revisa estos objetos:

COL
COLS

--------------------------------------------

14:12:51 SQL> desc col
Name Null? Type
----------------------------------------- -------- ---------------
TNAME NOT NULL VARCHAR2(30)
COLNO NOT NULL NUMBER
CNAME NOT NULL VARCHAR2(30)
COLTYPE VARCHAR2(106)
WIDTH NOT NULL NUMBER
SCALE NUMBER
PRECISION NUMBER
NULLS VARCHAR2(19)
DEFAULTVAL LONG
CHARACTER_SET_NAME VARCHAR2(44)

16:30:42 SQL> desc cols
Name Null? Type
----------------------------------------- -------- ---------------
TABLE_NAME NOT NULL VARCHAR2(30)
COLUMN_NAME NOT NULL VARCHAR2(30)
DATA_TYPE VARCHAR2(106)
DATA_TYPE_MOD VARCHAR2(3)
DATA_TYPE_OWNER VARCHAR2(30)
DATA_LENGTH NOT NULL NUMBER
DATA_PRECISION NUMBER
DATA_SCALE NUMBER
NULLABLE VARCHAR2(1)
COLUMN_ID NOT NULL NUMBER
DEFAULT_LENGTH NUMBER
DATA_DEFAULT LONG
NUM_DISTINCT NUMBER
LOW_VALUE RAW(32)
HIGH_VALUE RAW(32)
DENSITY NUMBER
NUM_NULLS NUMBER
NUM_BUCKETS NUMBER
LAST_ANALYZED DATE
SAMPLE_SIZE NUMBER
CHARACTER_SET_NAME VARCHAR2(44)
CHAR_COL_DECL_LENGTH NUMBER
GLOBAL_STATS VARCHAR2(3)
USER_STATS VARCHAR2(3)
AVG_COL_LEN NUMBER