Awesome, now I will not toggle b/w VDI and Desktop
Many time I have to make use of notepad to do stuff like below, is there any way to do same in Sql developer, itried but it's not working.
How I can implement it in sql developer itself.
I suggest you consider reading the documentation when you have questions about basic functionality.
That is often the BEST, and FASTEST way to learn.
You posted a similar question in the sql and pl/sql forum and you could have gotten that answer from the doc also.
Here is a link to the version 1.5 sql dev user guide just to show the doc has included that functionality and info from the beginning.
Just search that doc for 'regular expression'.
...a more up-to-date link to Sql Developer documentation can be accessed from the download page, click on "documentation":
For example, currently:
SQL Developer 17.3.1
Version 184.108.40.2069.0537, Updated October 17, 2017
...takes you to 17.3 documentation for installation, User's Guide and Reference guide, plus documentation for Data Modeller.