Search Results

find . -type f -name "*.sql" -print|xargs perl -i -pe 's/pattern/replaced/g'


this is simple logic to find and replace in multiple files & folders
Hope this helps.

Thanks
Zaheer

In c:/zaheer/123-456/sql/ folder i have below 7 sql files.

cv_abc_a.sql
cv_abc_b.sql
cv_abc_c.sql
vtemp_d.sql
vtemp_e.sql
cv_abc_f.sql
Exviews.sql

In Exviews.sql file i have mentioned...

what is RS err RS RS $0) here Please explian.

Thanks in advace

(1) Yes but how is this block different from the other 24? You will need this information in order to identify and replace this block correctly (out of the 25).

Ans: The 1st line and last line of...

Please suggest some code for the above queryASAP.

Thanks in advance.

(1) Yes but how is this block different from the other 24? You will need this information in order to identify and replace this block correctly (out of the 25).

Ans: The 1st line and last line of...

The above code is excuting but not replacing the file which is present in repl_file.Please suggest

---------- Post updated at 11:14 PM ---------- Previous update was at 11:10 PM ----------
...

Hi I tried with the above code but its not working.

I will explain you once again

In my xyz_abc.sql file there are multiple blocks.
Just imagine there are 25 blocks in xyz_abc.sql file in...

My sql file xyz_abc.sql in this file there are multiple sql block in this block I need to find the following block

rem Subset Rows (&&tempName.*)
CREATE VIEW &&tempName.* AS
SELECT *
FROM...