Feuerfest

Just the private blog of a Linux sysadmin

Better SQL*Plus output

  • May 13, 2025 •
  • IT •
  • Christian

Oracle's sqlplus tool is horrible to work with as it lacks many basic command line features. No tab-completition, no command history scrolling with Arrow-Up/-Down or the like and additionally the output formatting is near unreadable.

Hence I was delighted when I found out that command set markup csv on will switch to CSV output formatting.

Enable it the following way:

oracle@host:~$ sqlplus user/password @iXXXc1
SQL> set markup csv on

Tag