Getting Ref Cursor output as CSV

Published: 21 January 2019
on channel: SQL and Database explained!

3,677

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

On this page of the site you can watch the video online Getting Ref Cursor output as CSV with a duration of hours minute second in good quality, which was uploaded by the user SQL and Database explained! 21 January 2019, share the link with friends and acquaintances, this video has already been watched 3,677 times on youtube and it was liked by 7 viewers. Enjoy your viewing!

287,056