~$ cat /mnt/e/instantclient_23_6/glogin.sql -- -- Copyright (c) 1988, 2005, Oracle. 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 -- SET LINESIZE 200 PAGESIZE 50 SET SQLPROMPT "_user'@'_connect_identifier> "
~$ sqlplus.exe sakura/sakura@127.0.0.1:15210/orcl
SQL*Plus: Release 23.0.0.0.0 - Production on Wed Nov 20 17:53:11 2024 Version 23.6.0.24.10
Copyright (c) 1982, 2024, 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
SAKURA@127.0.0.1:15210/orcl>
Local Mode
$WORK_PATH/login.sql
~$ cat /home/sakura/login.sql SET LINESIZE 200 PAGESIZE 50 SET SQLPROMPT "_user'@'_connect_identifier> "
SQL*Plus: Release 23.0.0.0.0 - Production on Wed Nov 20 17:53:11 2024 Version 23.6.0.24.10
Copyright (c) 1982, 2024, 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
