Shulou(Shulou.com)05/31 Report--

Today, I will talk to you about the initialization file glogin.sql of sqlplus, which may not be well understood by many people. in order to make you understand better, the editor has summarized the following contents for you. I hope you can get something according to this article.

1. We enter select * from emp; in the sqlplus command line window to show that there will be overlapping lines as follows

We need to set set linesize 150 set pagesize 20 ourselves to display the rules, but when we re-open a sqlplus window, the settings will fail. In fact, every time we open sqlplus, we execute an initialization file called glogin.sql.

2 enter the oracle installation directory / product/11.2.0/dbhome_1/sqlplus/admin and there is a glogin.sql file

Vi glogin.sql can add set linesize 150 set pagesize 20 at the end.

Reopen sqlplus and enter select* from emp; as follows

After reading the above, do you have any further understanding of sqlplus's initialization file glogin.sql? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.