Recent content by Drillnot

I confirmed 16.0.0.2135 now allows date substitution variables to handle expressions as well as literal date formats. Thank you, Marco!

I'll add another vote for adding zoom to Help viewer. Thanks!

It looks like date type substitution variables are evaluating the input unlike previous versions like 15. According to Help, section 12.3, under "Type option", When I enter "sysdate" for the following query in a SQL window: select &<name="inputDate" type="date"> as "UserInputDate" from...

While you're at it, can you break the ON conditions onto separate lines?

When copying grid results to Excel as xlsx, leading and trailing spaces for VARCHAR2 columns are trimmed. If copying to Excel as xls, these spaces are not trimmed. Is this a preference to be set? The Copy to Excel function should not automatically trim spaces in any format, but a preference...

You can also go to Tools -> Preferences, select Window Types - SQL Window and check the box next to "AutoSelect statement". When you press your execute shortcut (which can be set under Preferences, User Interface-Key Configuration, Session / Execute), PLD will automatically select and execute...

Did the case sensitivity in the Files browser listing change with v. 8.0.1.1496? I am now seeing files with names starting with lowercase letters being sorted after all files with names starting in uppercase letters, i.e. "XYZ.sql" is listed before "abc.sql". Version 8.0.0.1480 sorted files...

We found this in version 8.0.0.1480 compared to 7.1.5.x. Suppose you want to replace any pair of single quotes with a single single quote character. Suppose you encounter 4 single quotes: '''' Version 8 will "Replace All" by leaving a single quote. ' Version 7 will "Replace All" by leaving...