Re: Updating a column with PL/SQL proc

From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Fri, 14 Dec 2001 13:04:43 GMT
Message-ID: <LNmS7.47243$wL4.342942@rwcrnsc51>

The first uses host variables.
"andrija" <ar35644_at_fer.hr> wrote in message news:9vckgu$he9$1_at_as201.hinet.hr...
> > begin
> >
> > execute immediate 'update test_plup set ' || clname || ' = :val1'
> > using val1;
> >
> > end;
> >
>
> What's the difference between
>
> execute immediate 'update test_plup set ' || clname || ' = :val1'
> using val1;
>
> and
>
> execute immediate 'update test_plup set ' || clname || ' = ' || val1;
>
>
>
>
>
>
Received on Fri Dec 14 2001 - 07:04:43 CST