use "exist" rule in model
checks if the value being validated can be found in the table column
ORA-00936: missing expression
The SQL being executed was: SELECT EXISTS(SELECT * FROM "table" WHERE ("field_id"='1'))
i think the query its should be like this
select count(*) from dual where EXISTS(SELECT * FROM "table" WHERE ("field_id"='1'))
| Q | A
| ---------------- | ---
| Yii version | 2.0.11
| PHP version | 5.6
| Operating system | Windows
| Database | Oracle 12c
@alvinux why did you close it?
i'm sorry, my bad, it is not yii2 problem but my extension that i used. my extension refer to yii\db\QueryBuilder instead of yii\db\oci\QueryBuilder
Most helpful comment
i'm sorry, my bad, it is not yii2 problem but my extension that i used. my extension refer to yii\db\QueryBuilder instead of yii\db\oci\QueryBuilder