who changed my code ?-USER_OBJECTS -

Posted on June 8th, 2008 by admin

How can one see if somebody modified any code?
The source code for stored procedures, functions and packages are stored in the Oracle Data Dictionary.

One can detect code changes by looking at the LAST_DDL_TIME column in the USER_OBJECTS dictionary view.

Example:

SELECT OBJECT_NAME,
TO_CHAR(CREATED, ‘DD-Mon-RR HH24:MI’) CREATE_TIME,
TO_CHAR(LAST_DDL_TIME, ‘DD-Mon-RR HH24:MI’) MOD_TIME,
STATUS
FROM USER_OBJECTS
WHERE LAST_DDL_TIME > ‘&CHECK_FROM_DATE’;


Add your opinion - this will move the pointer
get dashboard plugin?

Filed under: DataWarehousing, ERP, Interview Questions(& answers), Oracle Apps, PL/SQL, SQL

Free Dashboards

Here are some more interesting Articles
  • Discoverer Session, specific workbook, user ID and responsibility
  • Discoverer Session, specific workbook, user ID and responsibility
  • Discoverer Session, specific workbook, user ID and responsibility
  • STEPS REQUIRED TO CREATE A SIMPLE FLEX FIELD REPORT
  • Interface - UTL_FILE - SQL*LOADER -ORACLE GENERAL LEDGER -
  • FLEX FILED REPORTS -USER EXITS

    • Leave a Reply

    You must be logged in to post a comment.

    « what to monitor by DBA ?-Infrastructure availability Interface - UTL_FILE - SQL*LOADER -ORACLE GENERAL LEDGER - »

    • About InfoPurple

      InfoPurple is an Oracle Digest that collects best articles from the best minds from entire blogosphere. We collect them and post an excerpt and point back to the main site. This allows for a consolidated view of Oracle Apps related topics. If you would like to add your website to be included then please email us (infopurple8888 AT gmail DOT com) your web url. If you would like to get your website removed then send us an email and we will remove it. -- infoK purple