首页 > 数据库 >如何取消sqlplus后面的时间提示

如何取消sqlplus后面的时间提示

时间:2022-12-15 22:32:58浏览次数:34  
标签:11g 提示 ---- 取消 sqlplus Plus SQL -- admin

问题描述:如何取消sqlplus后面的时间提示,如下红色方框所示:

如何取消sqlplus后面的时间提示_SQL

解决方案:
[oracle@leo-11g-ogg admin]$ pwd
/u01/app/oracle/product/11.2.0/db/sqlplus/admin
[oracle@leo-11g-ogg admin]$ cat glogin.sql
--
-- Copyright (c) 1988, 2011, Oracle and/or its affiliates.
-- All rights reserved.
--
-- NAME
-- glogin.sql
--
-- DESCRIPTION
-- SQL*Plus global login "site profile" file
--
-- Add any SQL*Plus commands here that are to be executed when a
-- user starts SQL*Plus, or uses the SQL*Plus CONNECT command.
--
-- USAGE
-- This script is automatically run
--
ALTER SESSION SET nls_date_format = 'YYYY-MM-DD HH24:MI:SS';
set sqlprompt "_USER'@'_CONNECT_IDENTIFIER _date>"
--按如下进行修改.
[oracle@leo-11g-ogg admin]$ cat glogin.sql
--
-- Copyright (c) 1988, 2011, Oracle and/or its affiliates.
-- All rights reserved.
--
-- NAME
-- glogin.sql
--
-- DESCRIPTION
-- SQL*Plus global login "site profile" file
--
-- Add any SQL*Plus commands here that are to be executed when a
-- user starts SQL*Plus, or uses the SQL*Plus CONNECT command.
--
-- USAGE
-- This script is automatically run
--
ALTER SESSION SET nls_date_format = 'YYYY-MM-DD HH24:MI:SS';
set sqlprompt "_USER'@'_CONNECT_IDENTIFIER >"
[oracle@leo-11g-ogg admin]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Thu Dec 15 11:52:52 2022

Copyright (c) 1982, 2013, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


Session altered.

SYS@orcl >
SYS@orcl >

标签:11g,提示,----,取消,sqlplus,Plus,SQL,--,admin
From: https://blog.51cto.com/u_12991611/5946567

相关文章