First let me say that I've been using sql worksheet and text files to compile pl/sql objects before now. I LOVE pl/sql developer! This has saved me alot of time and is a good tool.
Currently I keep several sql scripts for a database. One that lists all the tables, indexes and constraints and another that lists the re-creatable objects suchs as procedures, functions, views etc. To make changes to tables I include one with alter commands in the sequence they occured. To update a remote database, I simply run the appropriate scripts.
I would like to get away from having to keep that library of scripts. Is there any way that I can generate a script that contains these objects through pl/sql developer or through an add-on?
Thanks
