You can put any of the procedure/function stuff inline in an SQL
statement, I think. Is that what you mean, or is an anonymous block
reusable outside of the context where you put it first?

Billy Rowe wrote:
>
> I have upgraded to V5R1 of Client Express.
>
> 2. How do you create an anonymous block, like you can do
>    on Oracle with SQL Plus, SQL Navigator, etc. without
>    having to create or replace a procedure?
>
>     ex:     Begin
>
>             .......
>
>             End
>
> TIA
>


--
Vern Hamberg

Would you like to see a challenging little arithmetic puzzle
that might get you or your kids or grandkids more interested
in math? Go to <http://cgi.wff-n-proof.com/MSQ-Ind/I-1E.htm>

Sillygism--

Something is better than nothing.
Nothing is better than a ham sandwich.
Ergo
Something is better than a ham sandwich.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.