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: Materialized view dynamic row count

Re: Materialized view dynamic row count

From: Geoff Muldoon <geoff.muldoon_at_trap.gmail.com>
Date: Wed, 12 Oct 2005 10:27:17 +1000
Message-ID: <MPG.1db703712378ec839896f9@news.readfreenews.net> 





connor_mcdon..._at_yahoo.com says...



> execute immediate 'select count(*) from '||c.view_name

> into l_count;




D'oh me. Thanks Connor.



I am in the habit whenever using execute immediate of declaring a varchar2 
named v_sql, populating the string and then calling it.  Had tried:



v_sql := 'select count(*) from '||c.view_name||' into '||l_count;
execute immediate v_sql;



and this was failing.



Geoff M
Received on Tue Oct 11 2005 - 19:27:17 CDT












Original text of this message













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