|
Besides being able to run an SQL statement(s) in the window, I would like to be able to create a block(i.e. begin,end) with cursor for loop,etc. but not have to create a procedure and then call it. |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? |> |> 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
As an Amazon Associate we earn from qualifying purchases.
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.