Entire Site
Free Trial
Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- PrintPrint
Chapter 5. Using SQL*Plus > Setting the Line Size
Setting the Line Size
You set the number of characters in a line using the SET LINESIZE command. Set the line size to 50 lines using the following SET LINESIZE command and run the new query shown in the following example:
SQL> SET LINESIZE 50 SQL> SELECT * FROM customers; CUSTOMER_ID FIRST_NAME LAST_NAME DOB ----------- ---------- ---------- --------- PHONE ------------ 1 John Brown 01-JAN-65 800-555-1211 2 Cynthia Green 05-FEB-68 800-555-1212 3 Steve White 16-MAR-71 800-555-1213 4 Gail Black 800-555-1214 5 Doreen Blue 20-MAY-70
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- PrintPrint