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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Unused Synonyms

Re: Unused Synonyms

From: Jared Still <jkstill_at_gmail.com>
Date: Mon, 23 Oct 2006 09:34:38 -0700
Message-ID: <bf46380610230934s702c4d93ob2eccc32e62c5d95@mail.gmail.com> 





On 10/19/06, Richard J. Goulet <rgoulet_at_kanbay.com> wrote:


>

>      stmt := 'select count(*) from '||a.synonym_name;

>




You might consider amending the above SQL to 'select count(*) from
'||a.synonym_name||' where rownum < 2';

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l


Received on Mon Oct 23 2006 - 11:34:38 CDT












Original text of this message













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