How To Change Sqlprompt In SQLcl
(Doc ID 2626244.1)
Last updated on AUGUST 17, 2023
Applies to:
Oracle SQLcl - Version 19.1 and laterInformation in this document applies to any platform.
Goal
How to change the default SQLPrompt in SQLcl?.
SQLcl supports SQL*Plus environment settings, commands, and behaviors. By default the SQLcl Prompt(SQL>) is same as SQL*plus.
SQLcl: Release 19.4 Production on Tue Jan 07 19:07:29 2020
Copyright (c) 1982, 2020, Oracle. All rights reserved.
Password? (**********?) ********
Connected to:
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production Version 18.4.0.0.0
SQL>
CAUTION
The sample program in this article is provided for educational purposes only and is NOT supported by Oracle Support Services. It has been tested internally and works as documented. Oracle can not guarantee that it will work in all possible configurations, so be sure to test it thoroughly in your test environment before deploying it.
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| CAUTION |
| Solution |
| _CONNECT_IDENTIFIER |
| _DATE |
| _O_VERSION |
| _O_RELEASE |
| _USER |
| _PRIVILEGE |
| More Examples |
| References |