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 …

SQLDev Trick: Alphabetized Column List in the Single Record Viewer

thatjeffsmith SQL Developer 0 Comments

This trick’s title might actually be longer than the content – so guaranteed QUICK read! Question from a reader: is there a way to alphabetize the columns in the Single Record View? Quick Answer: No… Column order is usually something the application architect or data …

Related Posts Plugin for WordPress, Blogger...