Article From:

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.


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 *