Including a SQL file within a SQL query In Oracle SQL Developer, is there any way to include a SQL file within a SQL query? Like the command \include{myfile.tex} in LaTeX. 

Example:


file1.sql contains FROM my_table;
file2.sql contains SELECT * \include{file1.sql}


Executing file2.sql from Oracle SQL Developer should be equivalent to executing SELECT * FROM my_table;.
In SQL*Plus, execute external scripts using @filename (http://docs.oracle.com/cd/E11882_01/server.112/e16604/ch_five.htm#i1210918).  

This also works in SQL Developer, just be aware of the differences between relative &amp; absolute directory.