Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dropping functions

baskar.l-2011272Apr 8 2008 — edited Apr 9 2008

Experts,
I have a function under the same schema created at different dates where one is valid and other is invalid.

how to drop the invalid one

SQL> select object_type,status,owner,CREATED,LAST_DDL_TIME from dba_objects where object_name like '%NUM_TO_WORD%';

OBJECT_TYPE STATUS OWNER CREATED
------------------ ------- ------------------------------ ---------------
LAST_DDL_TIME
---------------
FUNCTION VALID APPS 08-APR-08
08-APR-08

FUNCTION INVALID APPS 18-MAR-08
18-MAR-08

thanks,
baskar.l

Locked Post

New comments cannot be posted to this locked post.

Locked on May 7 2008

Added on Apr 8 2008

#general-database-discussions

10 comments

724 views