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 …

2 Reports You Might Enjoy in Oracle SQL Developer

thatjeffsmith SQL Developer 5 Comments

I keep telling people our reporting functionality is probably the most powerful AND overlooked feature in SQL Developer. Today I’m going to share 2 reports that I frequently forget about, that you may enjoy. Finding Unindexed Foreign Keys We all know this should not happen. …

Related Posts Plugin for WordPress, Blogger...