Re: Automatic Date/Time

Date sent: 17-JAN-1996 12:29:23
gerald

Try the following select. You will see what you want.

SQL> select * from all_objects
where object_name = '{yourfunction/package/procedure name}';

The create date and last access date will be listed.

Hope this helps.

Tom

>
> Oracle-L Group,
> What methods are available for "automatic" version control of SQL
> Code in Oracle (i.e., Functions)? COBOL 2 uses a reserved word of
> "DATE_COMPILED" to update this date every time the program is
> compiled. Is there anything like this in Oracle SQL or SQL+?
>
> Thank You,
> gerald_bowers_at_fmso.navy.mil

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
%                                                                            %
% Tom Mercadante                                                             %
% Database Administrator                                                     %
% SUNY Plattsburgh                                                           %
%                                                                            %
% BITNET   : MERCADTF_at_SNYPLAVB.BITNET                                        %
% INTERNET : MERCADTF_at_SPLAVA.CC.PLATTSBURGH.EDU      Computer Systems Center %
% PHONE    : (518)564-3013                           Kehoe 507               %
% FAX      : (518)564-4415                           Plattsburgh, NY 12901   %
%                                                                            %
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%