Getting Ref Cursor output as CSV
A quick video in response to an AskTOM question on how to get ref cursor output as CSV. At the time this video was made, SQL Developer does not do it natively, but a simple wrapper function will let you get the output in a format that you can easily cut-paste into Excel or similar tool.
blog: https://connor-mcdonald.com
twitter: / connor_mc_d
Subscribe for new tech videos every week
All other social media channels here: https://linktr.ee/connor
My current favorite Oracle stuff:
Favorite 12.2 feature: Almost all structural maintenance can be done online. No more outages.
https://docs.oracle.com/en/database/o...
Favorite 18c feature: Killing a runaway SQL without killing the entire session.
https://docs.oracle.com/en/database/o...
Favorite 19c feature: Handling JSON just got a lot easier!
https://docs.oracle.com/en/database/o...
/ @databasedude
#oracle #sql #refcursor