Added.
---
Josh Berkus wrote:
> Bruce,
>
> > OK, so what should the TODO item be?
>
> Go with the simple and intuitive:
>
> EXECUTE query_var INTO record_var;
>
> --
> -Josh Berkus
> Aglio Database Solutions
> San Fra
Bruce,
> OK, so what should the TODO item be?
Go with the simple and intuitive:
EXECUTE query_var INTO record_var;
--
-Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)---
TIP 9: the planner will ignore your desire to c
OK, so what should the TODO item be?
---
Josh Berkus wrote:
> Guys,
>
> > I'm not an Oracle bunny but they seem to have something vaguely similar
> > to what we do; they call it "EXECUTE IMMEDIATE" and the concept is
> > de
Guys,
> I'm not an Oracle bunny but they seem to have something vaguely similar
> to what we do; they call it "EXECUTE IMMEDIATE" and the concept is
> described as "Dynamic SQL".
Aha. I see it now; a pretty awful OO-package-style format. I don't think we
want to imitate this.
--
-Josh Berku
On Fri, Aug 01, 2003 at 01:06:18PM -0700, Josh Berkus wrote:
> As far as I can tell from my PL/SQL guide to Oracle8, PL/SQL does not permit
> exectution of strings-as-queries at all. So there's no equivalent in PL/SQL.
I'm not an Oracle bunny but they seem to have something vaguely similar
to w
Robert,
> I don't seem to have any plsql specfic documentation, and the rest of my
> oracle documentation isn't specfific enough. Anyone else?
As far as I can tell from my PL/SQL guide to Oracle8, PL/SQL does not permit
exectution of strings-as-queries at all. So there's no equivalent in PL/SQ
I don't seem to have any plsql specfic documentation, and the rest of my
oracle documentation isn't specfific enough. Anyone else?
Robert Treat
On Thursday 31 July 2003 00:12, Bruce Momjian wrote:
> Does Oracle have a syntax for this?
>
> -
Does Oracle have a syntax for this?
---
Robert Treat wrote:
> On Wednesday 23 July 2003 19:06, Bruce Momjian wrote:
> > Robert Treat wrote:
> > > On Wed, 2003-07-23 at 15:38, [EMAIL PROTECTED] wrote:
> > > > FOR myrec IN E
On Wednesday 23 July 2003 19:06, Bruce Momjian wrote:
> Robert Treat wrote:
> > On Wed, 2003-07-23 at 15:38, [EMAIL PROTECTED] wrote:
> > > FOR myrec IN EXECUTE myinfo LOOP
> > > biglist := myrec.info;
> > > END LOOP;
> >
> > One other thing, I hate when I have to do things like the above,
Robert Treat wrote:
> On Wed, 2003-07-23 at 15:38, [EMAIL PROTECTED] wrote:
> > FOR myrec IN EXECUTE myinfo LOOP
> > biglist := myrec.info;
> > END LOOP;
> >
>
> One other thing, I hate when I have to do things like the above, can we
> get a TODO like:
>
> allow 'EXECUTE var INTO record'
On Wed, 2003-07-23 at 15:38, [EMAIL PROTECTED] wrote:
> FOR myrec IN EXECUTE myinfo LOOP
> biglist := myrec.info;
> END LOOP;
>
One other thing, I hate when I have to do things like the above, can we
get a TODO like:
allow 'EXECUTE var INTO record' in plpgsql
Robert Treat
--
Build A Br
11 matches
Mail list logo
