SQL & PL/SQL

Hi,

I am trying to get information about the columns of tables in Oracle databases. In MySQL, show columns provides good deal of information.
But in Oracle, we do not have such equivalent call.
"describe" shows only the primary key.

But it does not show whether any column has unique constraint or an index.

I created a column in a table with unique constraint (but not a primary key), but it was not listed with CONSTRAINT_TYPE = 'U' in dba_constraints view, but was listed with CONSTRAINT_TYPE = 'C' - Check constraint.

Can someone pls guide how can we know this information about columns?

Thanks in advance for your time and guidance.

Best Regards.