IMO there's a bug in find & replace functionality.
I want to put a newline character before each comma. Steps to reproduce:
- Open a new SQL Window
- write "select c1,c2 from my_table"
- Click Find & Replace:
- Text to Find: ","
- Replace with: any text that ends with comma, i.e. "test,"
- Click "Replace all"
The PL/SQL Developer goes to 100% CPU usage, basically it makes an infinite loop and never finishes.
You can observe the bug if you keep clicking "Replace" button instead of "Replace all".
PL/SQL Developer version: 10.0.3.1701
Regards,
Jure
PS: also the "\n" is not replaced by the newline character when "Regular expressions" is checked. I found a blog post (http://blog.newtrics.com/?p=1058) that says this should work (referencing mr. Marco Kalter).
I want to put a newline character before each comma. Steps to reproduce:
- Open a new SQL Window
- write "select c1,c2 from my_table"
- Click Find & Replace:
- Text to Find: ","
- Replace with: any text that ends with comma, i.e. "test,"
- Click "Replace all"
The PL/SQL Developer goes to 100% CPU usage, basically it makes an infinite loop and never finishes.
You can observe the bug if you keep clicking "Replace" button instead of "Replace all".
PL/SQL Developer version: 10.0.3.1701
Regards,
Jure
PS: also the "\n" is not replaced by the newline character when "Regular expressions" is checked. I found a blog post (http://blog.newtrics.com/?p=1058) that says this should work (referencing mr. Marco Kalter).
