Oracle中查询程序包中函数重载的次数

例如查询dbms_backup_restore中backupBackupPiece函数重载的次数:

方法1
select text from dba_source where name = 'DBMS_BACKUP_RESTORE' and text like '%backupBackupPiece%';
查询结果的行数即是次数.

方法2
set long 1000000
SQL> spool /tmp/a.out
SQL> select dbms_metadata.get_ddl('PACKAGE','DBMS_BACKUP_RESTORE') from dual;
SQL> spool off

then in the spool file search for backupBackupPiece, you can count it and check details.