Why DESC When You Can INFO in Oracle SQLcl?

thatjeffsmith SQL Developer 6 Comments

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 …

Are Invisible Columns Really Invisible?

thatjeffsmith SQL Developer 2 Comments

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 …

More Column Copy Tricks in Oracle SQL Developer

thatjeffsmith SQL Developer 26 Comments

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 …