Re: Unusual question

From: Thomas Day <tday6_at_csc.com>
Date: Fri, 5 Mar 2004 10:58:18 -0500
Message-ID: <OF9C04D26E.AE3FCE84-ON05256E4E.00579586@csc.com>

Just a thought:

Use SELECT VIEW_NAME FROM DBA_VIEWS WHERE VIEW_NAME LIKE '%whateveryouwant';

Cut and paste the resulting view_name into a CREATE PUBLIC SYNONYM statement where you are not using the "$".

                                                                                                                                       
                      Keith Moore                                                                                                      
                      <kmoore7                 To:      oracle-l_at_freelists.org                                                         
                      @jcpenney.com>           cc:                                                                                     
                      Sent by:                 Subject: Unusual question                                                               
                      oracle-l-bounce                                                                                                  
                                                                                                                                       
                                                                                                                                       
                      03/05/2004 09:41                                                                                                 
                      AM                                                                                                               
                      Please respond                                                                                                   
                      to oracle-l

I teach Oracle certification classes at a local college and a student asked me a question that has me stumped. We were talking about the V$ views and he asked: How do DBA's in Germany query the views when they don't have a $ on their keyboards?

Thanks.

Keith Moore
Oracle Certified Professional
972-431-5126
kmoore7_at_jcpenney.comThe information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Fri Mar 05 2004 - 10:18:01 CST