My Oracle Support Banner

How To Change Sqlprompt In SQLcl (Doc ID 2626244.1)

Last updated on AUGUST 17, 2023

Applies to:

Oracle SQLcl - Version 19.1 and later
Information in this document applies to any platform.


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 - Production Version



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.


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
 More Examples

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