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 …

Viewing BLOBs in SQL Developer as Text

thatjeffsmith SQL Developer 1 Comment

I have talked about how to preview BLOBs (Binary Large Objects) as pictures… But someone on Stackoverflow asked how to read a BLOB value if it had text. So I spooled the content of my EMPLOYEES table to a txt file, as CSV, and then …

Related Posts Plugin for WordPress, Blogger...