My Oracle Support Banner

How To change Sqlprompt In SQLcl (Doc ID 2626244.1)

Last updated on MAY 16, 2020

Applies to:

Oracle SQLcl - Version 19.1 and later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.