SQL database Problems and Solutions in OneMap configuration in Oracle

SQL database Problems and Solutions in OneMap configuration in Oracle

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: