Search This Blog

Total Pageviews

Friday, 7 October 2011

Unix find list of first line of sql

List the first lines of sql files through find


find /home/anujs/Downloads/Script -name \*.sql -exec head -n 1 -v {} \; > report.txt


out put <<<<<<<<

cat report.txt

==> /home/anujs/Downloads/Script/search_view3.sql <==

==> /home/anujs/Downloads/Script/space.sql <==
col tsname format a15
==> /home/anujs/Downloads/Script/cc_ent_search_public_view_rev.sql <==
create or replace view search_public_view_rev

Oracle DBA

anuj blog Archive