SQL
怎么显示出具体哪些bdcdyh报错的啊 语句论坛上发不出来。试了几次 第一个select into 只能有一条值 程序返回的可能是多条 By default, a SELECT INTO statement must return only one row. Otherwise, PL/SQL raises the predefined exception TOO_MANY_ROWS and the values of the variables in the INTO clause are undefined. Make sure your WHERE clause is specific enough to only match one row.
Solution:
Improve the Where clause of your first SELECT INTO statement at line 11.
框出来的都存在多条可能,如果只需要一条就加限制条件,如果存在多条sjhqsj = 改成 sjhqsj in
页:
[1]