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. HR@orcl?? >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   HR@orcl?? > It’s …

What The Format? Making Your Code Pretty in SQL Developer

thatjeffsmith SQL Developer 43 Comments

This post is a tease. It’s also a request. Send me your ugly code. In version v4.2 of SQL Developer – to be released in calendar year 2016 – we’ll be offering a new formatter for your SQL and PL/SQL. It’s got a completely new …

Related Posts Plugin for WordPress, Blogger...