Search This Blog

Total Pageviews

Friday 22 July 2011

Oracle script maintain with comment

sql script comment
sql script maintenance
good example from http://blog.tanelpoder.com/?s=snapper to maintain the . sql script


put a line like this in the sql script

-- Purpose: Shows table, column, index, stats for a table

and you will get result like this

oracle@apt-lnxtst-01:~> grep -i Purpose: *.sql | awk -F: '{ printf("%20s %-50s\n", $1, $3) }'
roll1.sql to get the average writez of a rollback segment extent
table_stat2.sql Shows table, column, index, stats for a table

Oracle DBA

anuj blog Archive