Mungkin bisa membantu :
SELECT * FROM dba_objects WHERE object_type='PROCEDURE';

Thanks

IH
--- On Tue, 3/31/09, andre <[email protected]> wrote:

From: andre <[email protected]>
Subject: [indo-oracle] tanya info sebuah object
To: [email protected]
Date: Tuesday, March 31, 2009, 10:35 PM











    
            dear all,

bagimana ya kalao kita mau mengetahui informasi sebuah object di oracle

misalkan stored procedure,di creatednya kapan atau kapan terakhir di

update,saya coba dengan syntak

select * from dba_procedures ,cuma informasinya gak ada

mungkin bapak2x/ibu ada yang bisa membantu

mohon pencerahannya



salam

andre




 

      

    
    
        
         
        
        








        


        
        


      

[Non-text portions of this message have been removed]

Kirim email ke