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

Home -> Community -> Usenet -> c.d.o.misc -> What's + 0 does after a column name when creating view

What's + 0 does after a column name when creating view

From: <andyho99_at_yahoo.com>
Date: 9 Jun 2005 11:57:13 -0700
Message-ID: <1118343433.188218.106010@g47g2000cwa.googlegroups.com> 





Hi,



I was wondering why people put "+ 0" after a column when creating view.




For example,



CREATE OR REPLACE FORCE VIEW APPS.PER_ADDRESSES_V (a, b, c) as
select a,

       b + 0 b,
       c




.

.

.

Received on Thu Jun 09 2005 - 13:57:13 CDT












Original text of this message













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