Oracle startup settings

After starting sqlplus each time, you need to make some basic settings before editing the code. Today, let's take a look at the book and find a simple way to solve it.

Find the login. SQL (glogin. SQL) file in the oracle installation directory. My directory on the F disk is as follows: F: \ oracle \ product \ 10.2.0 \ db_1 \ sqlplus \ admin \ glogin. SQL

Open glogin. SQL and add the following code

-- My set
-- Specify the Default Editor opened by the ed command (notepad by default)
Define _ editor = 'd: \ Program Files \ editPlus-v3.11.421H \ EditPlus 3 \ editplus.exe'
-- Enable the output display and set the size.
Set serveroutput on size 100000
-- Set the number of characters displayed in each line
Set linesize 100
-- Set the number of records displayed on each page
Set pagesize 30

You do not need to set sqlplusw again later.

In addition, the SQL or txt text created using the ed command in oracle is generally stored in the C: \ Documents ents and Settings \ Administrator directory.


Author: gdn_wolf