Article From:https://www.cnblogs.com/linlf03/p/9967634.html

1、View database name

select name from v$database;

 

2、View instance names

select instance_name from v$instance;

 

3、View the installation directory of Oracle

Through the properties of the SQL PLUS shortcut key, and then find the starting position.

 

4、PL/SQL Error connecting Oracl: no matching authentication protocol

Solution: Find the sqlnet.ora file under Oracle’s installation path.

(C:\app\oracle\product\12.2.0\dbhome_1\network\admin\sqlnet.ora)

Add SQLNET.ALLOWED_LOGON_VERSION=8 at the end of the file

 

Link of this Article: Oracle Common SQL Statements

Leave a Reply

Your email address will not be published. Required fields are marked *