This content has been marked as final. Show 6 replies
I guess the wildcard character (%) is not supported, but Edit|Find does offer an option for regular expressions. I don't experience the issues you are seeing on either WinXP or (Oracle) Linux. Do you have the Match Case option checked off in either Edit|Find or the drop-down list to the right of the Binoculars icon?
If nothing else, you might want to try the Edit|Incremental Find Forward/Backward features.
SQL Developer Team
I can't see any option for regular expressions in Edit|Find (which looks to be the same as right-click Find/Highlight). Are you typing in the 'regexp_...' on the command line to the right of the binoculars? How did you get the 'in', 'like', 'between' to work?
I see there is a 'Starts With' option, which goes a little way into providing wildcard functionality.
What you've described seems to apply for the 'Filter', not the Edit|Find (Find|Highlight). I guess I'll be adding a feature request....
That's not supported in the grid's Find/Highlight dialog. You can feature request that.1 person found this helpful
I guess I somewhat misinterpreted your question. A filter should support SQL predicates having IN, LIKE, and so on, but I thought you were referring to the Find Text dialog. Ctrl-F displays that dialog for a SQL or PL/SQL code editor, or the Worksheet or Script Output. Find/Highlighting dialog only applies to the grids for Query Results or Object Viewer and does not offer an option for regular expressions.
Find Text does include an option for regular expressions, but it leaves something to be desired as the following thread shows:
Re: UI Package Body: Control-F Find: Find Next DOES NOT Work on REGEX=>3.1.05
Thanks for your replies. I'll raise a feature request for the find/highlight, as it would be great to have that working (we intend working with shared reports a lot in future).