SQL>column <column_name> format a20
// format the column_name with 20 alphabets
SQL>set pagesize 100
//set page size view to 100 alphabets, this decides how much length of the putty terminal will be occupied with the same headings. Like how much letter does a page consist of
SQL>set linesize 150
//set the size of the line to 150 alphabets
For more formatting options check out
http://goo.gl/DPXV9
No comments:
Post a Comment