tag:blogger.com,1999:blog-7176801629635494688.post7069454781237620166..comments2024-03-28T05:48:53.979+00:00Comments on SQL for Data Warehousing and Analytics: SQL Pattern Matching Deep Dive - Part 3, greedy vs. reluctant quantifiersASQLBaristahttp://www.blogger.com/profile/13350994132294695189noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-7176801629635494688.post-88069151281929015082017-01-13T13:00:55.064+00:002017-01-13T13:00:55.064+00:00Hi Stew,
Thanks for information. I have checked t...Hi Stew,<br /><br />Thanks for information. I have checked this in the last code version of SQL Dev (4.2) and the problem still persists. I am checking with Jeff Smith to see if 4.2 includes the latest and greatest version of the 12.2 JDBC driver. Keep you posted on progress.<br /><br />ASQLBaristahttps://www.blogger.com/profile/13350994132294695189noreply@blogger.comtag:blogger.com,1999:blog-7176801629635494688.post-42008747331820987732017-01-11T13:21:29.801+00:002017-01-11T13:21:29.801+00:00Hi Keith,
Concerning the reluctant qualifier ? in...Hi Keith,<br /><br />Concerning the reluctant qualifier ? in JDBC, the 12.2 documentation describes a workaround:<br /><br />"starting from Oracle Database 12c Release 1 (12.1.0.2), you can use the '{\ ... \}' syntax while using the ? character, so that the JDBC driver does not process it as a parameter marker and allows the SQL engine to process it"<br /><br />http://docs.oracle.com/database/122/JJDBC/JDBC-reference-information.htm#JJDBC-GUID-3454411C-5F24-4D46-83A9-5DA0BA704F5DStew Ashtonhttps://www.blogger.com/profile/10004507258457241890noreply@blogger.com