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 Enjoy! PS – I made this on my new rig …
Why DESC When You Can INFO in Oracle SQLcl?
INFORMATION is a new command available in SQLcl, a command-line interface to Oracle Database. [email protected]?? >help information INFORMATION ——– This command IS LIKE DESCRIBE but WITH more details about the objects requested. INFO[RMATION] {[schema.]object[@connect_identifier]} INFO+ will SHOW COLUMN statistics [email protected]?? > It’s available for tables and views, of course. Here’s a table. Note that we show the …
OT: Bad Tools Lead to Overly Verbose Code?
For some reason I decided to re-join a discussion in the SQL community from way back in 2012. THIS => "tbl_ is a tell for bad database design" via @datachick http://t.co/hq2BH73xic sorry @SQLRockstar — Jeff Smith (@thatjeffsmith) May 28, 2015 Karen started it, Thomas ran with it, and I decided I had to throw my 2 cents into it as …
Are Invisible Columns Really Invisible?
Today’s question: How are invisible columns treated with DESC, INFO and the GUI equivalent? Super quick, an INVISIBLE column is one that the user doesn’t see. They won’t be able to access it unless they know about it. Security by obscurity? No. Tom Kyte shows a few examples of the features usefulness, especially when adding columns to a table and …
SQLcl Commands: Info & Info+ – The New DESC?
We put out a HUGE update for our new SQL*Plus-style command line interface for Oracle Database. Forget how to install it, or how to connect: see the movie! Things that people really like to do in SQL Developer is pull up the object browsers to quickly see the things that a simple DESC doesn’t show. Things like comments primary keys …
More Column Copy Tricks in Oracle SQL Developer
I normally don’t blog on Sundays. But I was going through our Exchange, triaging your enhancement requests, and I found one that is ALREADY in the product. Actually I found a dozen or so that are already in the product, but I thought I’d talk about this one in particular. From Describe (Shift-F4) allow “Copy column names to clipboard” like …
Floating Panels and Describe Windows in Oracle SQL Developer
One of the challenges I face as I try to share tips about our software is that I tend to assume there are features that you just ‘know about.’ Either they’re so intuitive that you MUST know about them, or it’s a feature that I’ve been using for so long I forget that others may have never even seen it …