Regular Expression for notepad++ to find to_timestamp in oracle dump

Data dump from oracle contained to_timestamp entries which do not work when used in MS SQL Server.

The regular expression to find these entries in notepad++, to change them for MS SQL:
(non-greedy search of .*? did not work but this does)

to_timestamp\(([^(\))]*)\)

References:

Advertisements

One thought on “Regular Expression for notepad++ to find to_timestamp in oracle dump

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s