Shulou(Shulou.com)06/01 Report--

Today, I attended the OCP training and listened to the teacher talk about a little skill about oracle. I felt it was still very useful and wrote it down.

If you are interested in this document on the official website, you can also check it out. The document on the official website is accurate to time.

In our daily work, we use sqlplus / as sysdba to enter the oracle environment, and then switch to the production user, we will find that the display icon has not changed:

For example, after entering password for conn hr, it still appears as follows:

SQL >

So is there any way to show the users and instances of our current execution?

You can edit the following files:

This is the path to the default oracle installation:

/ u01/app/oracle/product/11.2.0/dbhome_1/sqlplus/admin/glogin.sql

(you can also cd $ORACLE_HOME and look for it in the relevant path.)

Edit the file and add this command below: SET SQLPROMPT "_ USER'@'_CONNECT_IDENTIFIER >"

As shown below:

The final sqlplus is purple. I will hide the name of the example here and will not show it to you.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.