question

dbkid avatar image
dbkid asked

How can I change sql prompt name?

I am using sqlplus to login to oracle.

While logging in its showing the prompt in development environment as follows.

ORACLE10G>

I want to see this prompt as SQL>.

In my test environment, I am getting it as SQL>

Are there are any settings we need to do this in dev environment?

oracle
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
Tariq Rahiman avatar image
Tariq Rahiman answered

SET SQLPROMPT 'SQL>'

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Anand 2 avatar image
Anand 2 answered

You can set it as

Set sqlp 'Your Desired Text>'

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.