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: how to create dbms_stast.gather_table_stats script

Re: how to create dbms_stast.gather_table_stats script

From: M.a.x G.e.decke <spam_at_gedecke.de>
Date: Fri, 23 Aug 2002 10:31:24 +0200
Message-ID: <ak4s0f$1778$1@redenix.uni-muenster.de> 





right now it looks like this:



SELECT 'call DBMS_STATS.GATHER_TABLE_STATS('''',''' || table_name ||
''',null)';' FROM user_tables;



is just can't keep in touch with all these apostrophes...



max
Received on Fri Aug 23 2002 - 03:31:24 CDT












Original text of this message













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