|
[oracle-l]
||
[Date Prev]
[09-2005 Date Index]
[Date Next]
||
[Thread Prev]
[09-2005 Thread Index]
[Thread Next]
Including special characters in query generation
- From: Chirag DBA <chiragdba@xxxxxxxxx>
- To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>, askdba@xxxxxxxxxxxxx
- Date: Fri, 2 Sep 2005 11:39:40 -0400
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
|
|
