Predefining all those Queries will take Forever! Not really, you Let the Server Help.
Copy an existing
Query. I prefer to use a template or sample Query to avoid leaving
traces of the old Query.
The content of my template helps get the
job done.
If you run the template you get a message
reminding you that a step was missed:
Back to our copy step:
You will want to change the Properties of
the New Query to something meaningful.
Then replace the code in the Copied "Design" window.
Oops! What to paste?
Next: Let Oracle Create your Code from the Data Dictionary.
Disclaimer
Use this information and these scripts at your own risk. As a condition of using these
scripts and information from this site, you agree to hold harmless both the
University of Arkansas Cooperative Extension Service and Bruce Knox for any
problems that they may cause or other situations that may arise from their use,
and that neither the Extension Service nor I will be held liable for those
consequences. The scripts and
information are provided "as is" without warranty, implied or
otherwise. Limitation of liability will
be the amount paid to the University of Arkansas specifically for this
information. (It was free:)
visits
http://www.uaex.edu/bknox/Summit_2003_p07.htm Predefining all those Queries will take Forever! Not really, you Let the Server Help.