Prepare for your Next Interview
This is a discussion on Execute .sql file from procedure within the Oracle forums, part of the Databases category; How to execute a .sql file from a procduer in oracle ?...
|
|||
|
Re: Execute .sql file from procedure
>>how to execute a .sql file from a procduer in oracle ?
sql> ed test.sql delete from emp where empno=7788; create or replace procedure test_pr as begin @test.sql; commit; end; / sql> execute test_pr; pl/sql procedure successfully completed. Sql> select * from emp 2 where empno =7788; no rows selected |
![]() |
|
| Thread Tools | |
| Display Modes | |
|
|
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| database procedure/function/package vs forms (program unit) package/procedure/packa | jkverma29 | Oracle | 0 | 09-27-2008 07:38 AM |
| Execute Procedure | Kanvik | Oracle | 2 | 09-23-2008 03:55 AM |
| Difference between Build script file, execute SQL | ily_saravanan | PeopleSoft | 1 | 09-07-2007 07:51 AM |
| How can I execute a file which include 'create table ' statement | Geek_Guest | Oracle | 1 | 07-17-2007 01:33 AM |