Today I ran into a scenario where I need to check if a table had an UNIQUE index.
Instead of writing a quick sql I decided to try the new (not so new) SQLcl tool. With the new describe (info), I could get a quick snapshot of the table DDL, Indexes and constraints.
Pretty cool.