sqlplus run all scripts in directory By ishara May 09, 2012 Get list of sql script. ls *.sql > allsql.txt Append '@' to every line. sed s/^/@/ allsql.txt > allsql.sql Now you can run all script. @allsql.sql Read more