oracle 查询语句报错

Question

SELECT * FROM TS_STATION WHERE SNAME = (SELECT DD_NAME FROM DICT_OCCUPATION WHERE DD_CODE = '1')

[Err] ORA-00932: inconsistent datatypes: expected - got CLOB

请问到底是哪有问题呢

Answer 1

=要改成in把 你后面查出来不止一个值呢，你让他等于哪一个。