The environment of a SQL plus session, like linesize, pagesize, etc., can be permanently set according to one’s own needs with the help of login.sql file. The settings can be set by a SET statement on each line. For Example:
SET linesize 100SET pagesize 100
The above settings can be verified on the SQL prompt by typing