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: local variable/column name conflict?

Re: local variable/column name conflict?

From: Bert Scalzo <bscalzo01_at_7-11.com>
Date: Wed, 19 May 1999 14:15:18 -0500
Message-ID: <7hv2dj$pnb$1@news.ses.cio.eds.com> 





Never do this. PL/SQL order of precedence is column names first during
parse resolution. SO this will always return all rows. This is a common
PL/SQL mistake. Oracle education recommends in their training to
prefix all var names with v_


Received on Wed May 19 1999 - 14:15:18 CDT












Original text of this message













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