Try something like
select u.constraint_name, u.table_name, column_name, position, constraint_type 
 from   user_cons_columns u, all_constraints a
where column_name = 'COL_NAME'
and u.table_name = 'TABLE_NAME'
and u.owner = 'OWNER'		-- if needed
and u.constraint_name = a.constraint_name

> -----Original Message-----
> From:	Manish Jain [SMTP:memanishjain@y...]
> Sent:	Saturday, July 21, 2001 11:50 AM
> To:	professional vb
> Subject:	[pro_vb] Check Constraints
> 
> 
> Is it possible to check all the constraints on a particular Table in 
> oracle(While inserting records from VB Using SQL) like is it a PKEY Or 
> FKEY or NOT NULL.......
> Thanks In Advance...
> Bye for now...
> Bye.
> X X X X X X X X X X X X X X
> Manish Jain
> Academic Head
> Aptech Computer Education
> X X X X X X X X X X X X X X
> 
>