ORA-00942: 表或视图不存在

### Error querying database.  Cause: java.sql.SQLSyntaxErrorException: ORA-00942: 表或视图不存在

### The error may exist in com/glxy/springboot/mapper/UserMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT * from  SYS_USER
### Cause: java.sql.SQLSyntaxErrorException: ORA-00942: 表或视图不存在

; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00942: 表或视图不存在
] with root cause

java.sql.SQLSyntaxErrorException: ORA-00942: 表或视图不存在

Whitelabel Error Page

This application has no explicit mapping for /error, so you are seeing this as a fallback.

Wed Jan 31 15:27:30 CST 2024

There was an unexpected error (type=Internal Server Error, status=500).

错误原因：引用另一个模式中的表或视图时遇到ORA-00942错误，因为需要在表名前加上模式名。

错误写法：没加模式名medicine，报错

@Select("SELECT * from  SYS_USER")

正确写法：加上模式名medicine

@Select("SELECT * from \"medicine\".SYS_USER")

 成功显示：