tag:blogger.com,1999:blog-4818542164384221282.post9156495243356162470..comments2024-03-25T17:53:49.828+08:00Comments on Grassroots Oracle: APEX matures => sequence usageScott Wesleyhttp://www.blogger.com/profile/18106937181788036683noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-4818542164384221282.post-28847106810431538042012-03-06T12:50:00.796+08:002012-03-06T12:50:00.796+08:00Hi
A quick google for oracle double quotes uncov...Hi <br /><br />A quick google for oracle double quotes uncovered this relevant <a href="http://en.allexperts.com/q/Oracle-1451/2008/1/Usage-quote.htm" rel="nofollow">response</a>.<br /><br />Essentially, double quotes around identifiers will be case-sensitive. <br /><br /><i>select "emp_seq".nextval from dual;</i><br /><br />will not work unless you created the sequence with<br /><i>create sequence "emp_seq";</i><br /><br />In general, best to avoid using double quotes unless absolutely necessary.Scott Wesleyhttps://www.blogger.com/profile/18106937181788036683noreply@blogger.comtag:blogger.com,1999:blog-4818542164384221282.post-55511684601176928032012-03-06T08:20:32.945+08:002012-03-06T08:20:32.945+08:00How does select "EMP_SEQ".nextval work w...How does select "EMP_SEQ".nextval work with the double quotes? I get a ORA-02289: sequence does not existAnonymousnoreply@blogger.com