Comments
- Phil Dunn (@Phil_Oracle) on Oracle’s New T5 TPC-C: Where’s the SPARC?, Part II
- ODBC on Installing the Netezza ODBC Driver.
- ashish on View deleted data in Netezza with view_deleted_records.
- Gary on Installing the Netezza ODBC Driver.
- venkat on Installing the Netezza ODBC Driver.
- Gary on EMCA Fails With Error “Failed to allocate port(s) in the specified range(s) for the following proces
- arnab on EMCA Fails With Error “Failed to allocate port(s) in the specified range(s) for the following proces
- Hank Classe on ANS1017E (RC-50) Session rejected: TCP/IP connection failure
- Sean Robinson on Registering with Multiple listeners.
- Gary on Sending nzevent emails for system state changes.
Meta
Category Archives: PLSQL
Oracle Date Time function, add_year
Oracle has no add_years functionality, but you can simply use add_months to get to it.
Using DBMS_FILE_TRANSFER with ASM.
Using DBMS_FILE_TRANSFER with ASM.
User cannot see package body.
A database user could not see the package body of another users package. Even with execute on the package granted, this still was not possible. That seemed odd, but here’s how oracle works it.
Posted in Configuration., Oracle, PLSQL
Tagged Access, DBA_SOURCE, DBA_SYS_PRIVS, package, PACKAGE~BODY
4 Comments