Friday, January 20, 2012

DBA: DC City Stories: Make SQLPlus Results Pretty!

Here are some common commands for the users of SQLPlus to make our results readable:
set PAGESIZE 100
This sets number of rows that appears before another header is printed. You can exclude the header all together by setting the value to 0.
set WRAP off
This ensures the results don't wrap to the next line if it's too long.
col column_name for a25 
This specifies a specific column size. Substitute the name of the column in, and the desired size in the last parameter.

No comments:

Post a Comment