RE: Data specs of columns

From: Bob Metelsky <bmetelsky_at_cps92.com>
Date: Fri, 15 Nov 2002 11:48:48 -0800
Message-ID: <F001.00504A7F.20021115114848@fatcity.com>

> Look at DBA_CONS_COLUMNS
>
> Igor Neyman, OCP DBA
> ineyman_at_perceptron.com
>

I see, thank you

select uc.constraint_type, uc.constraint_name, ucc.column_name, uc.search_condition

	 from user_constraints uc, user_cons_columns ucc
	 where uc.owner = 'BOB' and
	 uc.constraint_name = ucc.constraint_name and 
	 uc.table_name = 'ANAME' ;

#####################################################

I'm guessing the "computed" is not available??

select table_name, comments
 from dict
where comments like '%comp%' ;

select column_name 
from user_col_comments 
where  column_name like  '%COMPU%' ;

Thanks again
bob

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bob Metelsky
  INET: bmetelsky_at_cps92.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Fri Nov 15 2002 - 13:48:48 CST