Feature request - Export user objects from object browser

[Rob van Rijen]

It would be a very nice feature if you could export user objects directly from the object browser by right-clicking one or more selected objects.

I use export user objects a lot to prepare release scripts, but it is not easy to find the relevant objects in that list. Usually I will create a custom folder in the object browser with all the objects in my project. It would be useful to export these objects from the browser.

 

[Marco Kalter]

I have added this to the list of enhancement requests.

At the moment you can select the objects, and drag & drop them to an editor, and select "DDL" from the drag & drop list. Unfortunately the trailing slashes are missing from PL/SQL objects in this case.

 

[Rob van Rijen]

Thanks Marco!

 

[Rob van Rijen]

I have been thinking some more about this... maybe the solution can be found in the 'export user objects' window. The is currently no filtering option in there, except for a user selection.

The object browser however has a nice search filter, where you can type a (partial) name an object or filter objects modified before/after a date.

If that filter would be available in the 'export user objects' window, that would make it so much easier to export my relevant objects.

That is maybe an easier and more flexible solution!

 

[Marco Kalter]

We'll consider this.

Note that the Export User Objects has some filtering and selection options. You can double-click on the Name and Type heading of the list and enter a filter (e.g. emp% for all object names starting with EMP).

You can right-click on the object list to save or load a filter or selection.

 

[Rob van Rijen]

Thanks for that tip Marco! I work with PL/SQL Developer on a daily basis for almost 20 years... I even have the t-shirt! But I never knew this option existed.

Even though I still think a filter like the object browser would be nice, you've really helped me with that tip. I use export user objects all of the time to create my release scripts.