Mostly Making oracle easy, mostly:
Search for:
In SQL Developer

INFO vs DESC – Learning About your Oracle Schema Objects at the Command Line

1 Min Read

Here’s an 8 minute video walk through of using INFO and DESC in Oracle SQLcl.

You can decide what works better for you – hey, maybe you’ll decide to use both!

  • INFO shows more info
  • INFO+ shows more info with more stats
  • You can INFO a package OR a package.procedure
The asterisk (*) denotes the Primary Key column(s) for the table.
Info, plus some stats.
Get a code block for an entire package or just a single procedure.

Enjoy!

PS – I made this on my new rig

Mac Mini, 4k screen, but I filmed for 1080p resolution. I’m also using a new logitech mic/HD video camera. Please let me know if the fidelity is ‘good enough.’ I’ll probably never be as fancy as Connor, but I’m aiming to get better as I go 🙂

Author

I'm a Distinguished Product Manager at Oracle. My mission is to help you and your company be more efficient with our database tools.

Related Posts

1 Comment

  1. bdelmee Reply

    Hi Jeff, I enjoyed sqlcl very much while i could use it, but unfortunately that stopped several releases ago.
    Will 18.4 re-introduce sql.bat for those who need the tweaking it allowed ?

Reply To bdelmee Cancel Reply