Oracle configures SQL database Problems and Solutions in OneMap, oracleonemap

Oracle configures SQL database Problems and Solutions in OneMap, oracleonemap

Error ORA-00900: Invalid SQL statement, error: ORA--00942: Table or view does not exist after clicking OK

Analysis: prompt is a printing function in Oracle. If you want to execute an SQL file with a prompt in PLsql, the above error will be reported. on the Internet, it was found that the DBA permission was used to execute this SQL statement, it must be NORMAL, but it will eventually fail.

Solution:

Open CMD, go to SQLPLUS, or directly click SQLPLUS in the application development of the client, enter the user and password for executing the SQL, and go to SQL>

Enter @, drag the SQL file to the PLSQL window, and press enter to execute.

As follows:

SQL> @ C: \ A. SQL

========================================================== ===== Gorgeous split line ============================================ ========================

Running result:

 

 

A database cainiao. You are welcome to criticize and correct it.