oracle单引号和双引号的区别？

by

初学oracle，不知道oracle单引号和双引号的区别，如下面两条sql, 不知道为什么第二条不正确，先记下，希望能快点解决：

SQL> select ‘ab’ || ‘cd’ from dual;

‘AB’

—-

abcd

SQL> select “ab” || “cd” from dual;

select “ab” || “cd” from dual

*

第 1 行出现错误:

ORA-00904: “cd”: 标识符无效

1 thought on “oracle单引号和双引号的区别？”

  1. I relish, result in I found just what I used to be looking for. You have ended my 4 day lengthy hunt! God Bless you man. Have a great day. Bye

Comments are closed.