Toad World® Forums

DDL Script generation (Oracle 9i)


#1

A table on the dialog allows you to select entities to generate DDL for.
It would be helpful to be able to select which procedures, views etc to generate for. This would allow DDL for a subset of the procedures, views, etc to be created.
Thanks
Malcolm


#2

I’d also find it helpful to be able to generate package specs and package bodies seperately.
Malcolm


#3

Hello Malcolm,

Thanks for your feedback.

It would be helpful to be able to select which procedures, views etc to generate for. This would allow DDL for a subset of the procedures, views, etc to be created.

Yes, in the future we plan to enhance the items selection for script generation. This request has already been raised and is registered under CR # 36 513.
Let me note that this request has not high priority, so therefore I write: “in the future”. Unfortunately, at the moment I’m not able to tell you when exactly it will be.

Now, you select what procedures, views etc. should be generated in the Properties dialog | General tab | Generate checkbox. It is selected by default.

…generate package specs and package bodies seperately.
Do you like to generate specs of all your packages and then bodies of all your packages? Now it’s generated by packages - specs and body separately for each package.

Thanks for the details.

Regards,

Vladka


#4

Hello Vladka

Thanks for the reply.

…generate package specs and package bodies seperately.
I would like to generate one file containing all the package specs and a different file
containing all the package bodies.
Or possibly one file with all the specs first, then all the bodies.

Regards,
Malcolm


#5

Hello Malcolm,

Thanks for the details. I’ve created a new CR for this - 43 619.
We will deal with this task.

Thanks for your co-operation!

Regards,

Vladka + TDM Team