在这里插入图片描述
修改用户名为sys as sysdba
sysout无法输出问题:
将sqlplus/admin/glogin.sql的设置如下:
目录在oracle安装目录的product下:

– define vi as sqlplus editor
DEFINE _EDITOR = vi
set pagesize 999
set linesize 150
– set sql prompt like ‘SYS>’
set sqlprompt "&_user> "
set serveroutput on
set feedback off
alter session set nls_date_format=‘yyyy-mm-dd hh24:mi:ss’;
set feedback on

更多推荐