Search This Blog

Tuesday, 11 November 2025

remove spaces from SQL script in notepad++

 

  1. Go to Search -> Replace
  2. Select "Regular expression" under Search mode.
  3. Use ^\s* for "Find what" and leave "Replace with" blank.
  4. Click Replace all

No comments:

Create DB link in another db user

 To test / create the db link in another db user schema following procedure can be used. create or replace procedure tst_user.dblink   is ...