Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SQL Developer How to export store procedures into separate files?

I am using Oracle SQL Developer 3.2 and I have about 100 stored procedures/functions that I'd like to export them into separate individual files. Here's what I'd like to achieve:

  1. Each file name should be the same as the stored procedure/function name.
  2. The file content is just the content of the stored procedure/function, as if I open the stored procedure, copy and paste into a text file and save.

Any one knows how to do it? Thanks.

like image 557
neo Avatar asked Jun 10 '26 15:06

neo


1 Answers

As a1ex07 stated in his comment. You can achieve that. Go Tools -> Database Export -> Select the file where you want to create stored procedure/function and select the connection name -> Types to Export -> Specify Object -> Specify Data -> Finish

enter image description here

enter image description here

like image 132
Sathiya Kumar V M Avatar answered Jun 12 '26 12:06

Sathiya Kumar V M