What are the pros and cons of stored procedures vs queries in database systems?
I am using Oracle Database 11g Express Edition. When I run a file in SQL Command Line, I just get a PL/SQL procedure successfully completed message but do not get any output from the query stored in the first.sql file. How can I get my output?