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

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




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

select “ab” || “cd” from dual


第 1 行出现错误:

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

Share Post:

About Author


Recommended Posts

1 Comment

  • 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 for this article!