Storing and running a sql script in the database.
From: Terrian, Thomas J Mr CTR DLA J6DIB <Tom.Terrian.ctr_at_dla.mil>
Date: Fri, 3 Apr 2009 12:52:16 -0400
Message-ID: <B538F62DA0448741B308EA69417CC30201462A2F_at_COL1SMX19.USE.AD.DLA.MIL>
I have a simple sql script that selects from a couple of tables. What I would like to do is store the script in the database and run it from there. For example, instead of _at_test.sql going to the O/S to find test.sql, I want it to find the script in the database somewhere. Does anyone know how to do this?
Date: Fri, 3 Apr 2009 12:52:16 -0400
Message-ID: <B538F62DA0448741B308EA69417CC30201462A2F_at_COL1SMX19.USE.AD.DLA.MIL>
I have a simple sql script that selects from a couple of tables. What I would like to do is store the script in the database and run it from there. For example, instead of _at_test.sql going to the O/S to find test.sql, I want it to find the script in the database somewhere. Does anyone know how to do this?
I know I can rewrite it into a stored procedure but I would rather just leave it as a sql script.....any ideas?
Thanks,
Tom Terrian
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Apr 03 2009 - 11:52:16 CDT