Summary of common Oracle database problems and solutions (i)

Development often use ORALCE database, the use may encounter various types of error prompts, such as: Ora-00933:sql command did not end correctly, ORA-009242 and so on, for this record accumulation for their own is still very helpful, today on the record some of the previous problems, The back will slowly complement the improvement.

Error hint: ORA-00942: Table or view does not exist

Figure 1-1

Figure 1-2

In the development process using the PowerDesigner design database and export scripts, in the execution of the script is a problem, to open powerdesigner view the design of the table, found that the table name was "" cited (figure 1-2), sure enough, The query condition with double quotation marks did query the result, but why PowerDesigner created the table with double quotation marks, finally found the problem through other methods, the original is the reason for the PowerDesigner setting, the problem is resolved after this modification. The specific modifications are as follows:

Figure 1-3

Figure 1-4

Click on the above operation to confirm the save, see again will not display double quotation marks, the above problem is because, the lack of double quotation marks, so the query, insert, and other Operation tips table does not exist.

Figure 1-5

Exporting the script again will not have double quotes.