Skip to Main Content

SQL Developer Data Modeler

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Scripts and searching

KevinDavisMay 4 2012 — edited May 7 2012
The find object capability is useful but I do not see an intrinsic means to search code contained in "Before Create", "After Create" and "End of script" scripts? Not that I'm bashful about grepping the XML.

I have been placing breadcrumb comments in my scripts so I can see their provenance in the exported DDL -- a preference enhancement perhaps? (Particularly useful for code review where it would be easy to overlook code attached to objects in SDDM and that would otherwise be needles in a haystack amongst the exported DDL)

So what have I been putting into scripts? Not much since heavy lifting scripts and PL/SQL are best left outside of SQL Developer Data Modeler. My scripting with SDDM has been for materialized view logs since I don't see the means to create them directly in SDDM.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 4 2012
Added on May 4 2012
1 comment
237 views