oracle rem inserting into,oracle login的设置

在window系统针对Oracle登录调试设置登录会话的各种信息,从而定制login.sql.

在默认的情况下Oracle的默认登录执行的sql目录在login.sql所在目录

(D:\app\Administrator\product\11.1.0\db_1\sqlplus\admin)然后根据Kyte写

的login文件，修改一点符合自己的需要。

但是在有时候修改次文件不起作用,可能是Oracle中登录执行路径问题.

检查如下:

1.在运行"regedit"

2.选择KEY_LOCAL_MACHINE中的SOFTWARE,选中其下的Oracle目录中的Key_oradb11g_home1,

在右边的显示栏中显示各种信息.检查SQLPATH是否为你存放登录SQL所在的目录,如果不是修改即可.

你会发现在windows下调用vi不正常,可以修改一下定义：

define _editor=D:\program file\UltraEdit-32\Uedit32.exe

备注:我采用的Uedit32你也可以定义为记事本.

REM turn off the terminal output - make it so SQLPlus does not

REM print out anything when we log in

set termout off

REM default your editor here. SQLPlus has many individual settings

REM This is one of the most important ones

REM define _editor=vi

define _editor=C:\Program Files\Notepad++\notepad++.exe

REM serveroutput controls whether your DBMS_OUTPUT.PUT_LINE calls

REM go into the bit bucket (serveroutput off) or get displayed

REM on screen. I always want serveroutput set on and as big

REM as possible - this does that. The format wrapped elements

REM causes SQLPlus to preserve leading whitespace - very useful

set serveroutput on size 1000000 format wrapped

REM Here I set some default column widths for commonly queried

REM columns - columns I find myself setting frequently, day after day

column object_name format a30

column segment_name format a30

column file_name format a40

column name format a30

column file_name format a30

column what format a30 word_wrapped

column plan_plus_exp format a100

REM by default, a spool file is a fixed width file with lots of

REM trailing blanks. Trimspool removes these trailing blanks

REM making the spool file significantly smaller

set trimspool on

REM LONG controls how much of a LONG or CLOB sqlplus displays

REM by default. It defaults to 80 characters which in general

REM is far too small. I use the first 5000 characters by default

Set long 5000

REM This sets the default width at which sqlplus wraps output.

REM I use a telnet client that can go upto 131 characters wide -

REM hence this is my preferred setting.

set linesize 131

REM SQLplus will print column headings every N lines of output

REM this defaults to 14 lines. I find that they just clutter my

REM screen so this setting effectively disables them for all

REM intents and purposes - except for the first page of course

set pagesize 9999

REM here is how I set my signature prompt in sqlplus to

REM > I use the NEW_VALUE concept to format

REM a nice prompt string that defaults to IDLE (useful for those

REM of you that use sqlplus to startup their databases - the

REM prompt will default to idle> if your database isn't started)

define gname=idle

column global_name new_value gname

select lower(user) || ||

substr( global_name, 1, decode( dot,

0, length(global_name),

dot-1) ) global_name

from (select global_name, instr(global_name,'.') dot

from global_name );

set sqlprompt '[&gname]# '

REM and lastly, we'll put termout back on so sqlplus prints

REM to the screen

set termout on