Site icon An Oracle Spin by Alex Lima

SQLcl to view DDL

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.

 

Exit mobile version