oracle錯(cuò)誤：ORA-00920: 無效的關(guān)系運(yùn)算符，請(qǐng)問應(yīng)該怎么解決？bl20130401342在哪里？應(yīng)該是column name=data的位置。例如：SQL> select*from

oracle錯(cuò)誤：ORA-00920: 無效的關(guān)系運(yùn)算符，請(qǐng)問應(yīng)該怎么解決？

bl20130401342在哪里？應(yīng)該是column name=data的位置。例如：SQL> select*from testmain where idselect*from testmain where id*第1行出現(xiàn)錯(cuò)誤：ora-00920:關(guān)系運(yùn)算符無效SQL> select*from testmain where id=1，unselected line

是連接符號(hào)。例如，如果您選擇兩個(gè)數(shù)字，一個(gè)AAA，一個(gè)bbbaaa | BBB，那么它就是aaabbbselect“AAA”。您還可以在字段中添加字符串關(guān)鍵字：Oracle connection operator double vertical bar“|”將兩個(gè)字段字符串連接在一起。連接運(yùn)算符是雙豎條“|”，通過連接操作將兩個(gè)字段字符串連接在一起。例如，SQL代碼select uname | age as “name and age”from uinfo result is:name and age black hair 25 purple hair 19還可以在結(jié)果集中添加字符串SQL代碼select uname | age as “name and age”from uinfo black hair age:25 purple hair age:19