[askdba] Re: Including special characters in query generation

  • From: "Dan Petric" <petricdan@xxxxxxxxxxx>
  • To: askdba@xxxxxxxxxxxxx
  • Date: Sat, 03 Sep 2005 10:50:39 +0300



select 'exec dbms_stats.gather_schema_stats
(ownname=>'''||username||''',estimate_percent=>dbms_stats.auto_sample_size,method_opt=>''for
all columns size repeat'',degree =>7)' from dba_users;


Regards
Dan.

On Fri, 2 Sep 2005 11:39:40 -0400, "Chirag DBA" <chiragdba@xxxxxxxxx>
said:
> I want to generate a script for all users.
>  What is wrong here? There is one set parameter to set special characters 
> off.
>  select 'exec dbms_stats.gather_schema_stats 
> (ownname=>''''||username||'''||' 
> estimate_percent=>dbms_stats.auto_sample_size,method_opt=>'||'''for all 
> columns size repeat''',degree =>7)' from dba_users; 
> select 'exec dbms_stats.gather_schema_stats 
> (ownname=>'||'''||username||'''||' 
> estimate_percent=>dbms_stats.auto_sample_size,method_opt=>'||'''||for all 
> columns size repeat||''',degree =>7)' from dba_users;
>  can anyone tell me what is missing here ? 
>  Regards - Chirag

-- 
http://www.fastmail.fm - A no graphics, no pop-ups email service


Other related posts: