Re: Select start with connect prior in Forms 4.5
From: (wrong string) ädter <staedter_at_mail.boku.ac.at>
Date: 1997/08/20
Message-ID: <33FAA16C.7FA89EBA_at_mail.boku.ac.at>#1/1
Date: 1997/08/20
Message-ID: <33FAA16C.7FA89EBA_at_mail.boku.ac.at>#1/1
Tan Gwan An wrote:
> Dear Oracle fans,
>
> Can I use the SQL "select .... from .... start with .... connect by
> prior ..." in Forms 4.5 (Dev2K version 1.4) / Win 95 or
> should I use the FORMS_DDL (dynamic sql) or
> create view ?
>
> TIA,
> Tan Gwan An (tga_at_cbn.net.id)
I am using exactly this kind of statement in a Forms application, and
the
START WITH clause works in both PL/SQL triggers and a block's
DEFAULT WHERE clause.
(In the DEFAULT WHERE clause it didn't work until Dev2K 1.2, though.)
Hope that helps.
-- Robert Städter
University for Agriculture
Vienna, Austria
Received on Wed Aug 20 1997 - 00:00:00 CEST