devxlogo

Setting the SQL Plus Environment With login.SQL File

Setting the SQL Plus Environment With login.SQL File

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

size=3>
The above settings can be verified on the SQL prompt by typing

devx-admin

Share the Post: