Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Q about TRUCATE command within stored procedure

Re: Q about TRUCATE command within stored procedure

From: PaulCinVT <paulcinvt_at_aol.com>
Date: 28 Jul 1999 19:18:24 GMT
Message-ID: <19990728151824.03573.00001793@ngol01.aol.com>


In article <YCnl3.73$xN4.786_at_news3.mia>, "IIFThen" <msessions_at_aldensys.com> writes:

>Within a stored procedure, is there a FAST way to do the following:
>
>(1) delete rows
>(2) insert rows
>(3) update rows
>

Use the /*+ APPEND/ hint for inserts... Paul in VT Received on Wed Jul 28 1999 - 14:18:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US