Include SQL file to another SQL file
I have a specific SQL file that may be "connected" to another, more generic SQL init file.
Is it possible to somehow include refere开发者_如何学Gonce from one SQL file to another SQL file?
I am using Oracle and the DB is populated using Spring DataSourceInitializer
class.
If you are using SQL*Plus to run your script, you can use the @ (or @@) sign to include another SQL script.
See the manual for details:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ch12002.htm#i2696724
http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ch12003.htm#i2696759
精彩评论