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.>
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