Sunday, 30 January 2011

How to set column width in sqlplus?

Step1: Make a note of the columns you would like to set the width for.

Step2: Use the following syntax to set the column widths:
For varchar2 columns

SQL> column <column_name> format a<width no.>
For numeric columns

SQL> column <column_name> format <width no.>

No comments:

Post a Comment