Re: coding PL/SQL program more easly and quickly ?

From: <tjmxyz_at_my-deja.com>
Date: 2000/08/04
Message-ID: <8mdt32$9cb$1_at_nnrp1.deja.com>#1/1


What Dev Tool are you using?
If PL\SQL you could use DBMS_SQL but I think the code would be even more nasty then the simple:
> PKGCommon.DataMember1;
> PKGCommon.DataMember2;
> PKGCommon.Function1;
> PKGCommon.Function2;

In article <8mdel7$q7m_at_netnews.hinet.net>,   "Chris" <stvllium_at_ms18.hinet.net> wrote:
> Hi, all
>
> Is there have any way could convert Code1 to Code2 :
>
> -- Code1, use package name per member.
> PKGCommon.DataMember1;
> PKGCommon.DataMember2;
> PKGCommon.Function1;
> PKGCommon.Function2;
> PKGCommon.Function3;
>
> -- Code2, use package name once only.
> with PKGCommon do
> begin
> DataMember1;
> DataMember2;
> Function1;
> Function2;
> Function3;
> end;
>
> Thanks
>
> Chris
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Aug 04 2000 - 00:00:00 CEST

Original text of this message