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.

Posted in Dates, Functions, PLSQL | Tagged , , , , | Comments Off

Using DBMS_FILE_TRANSFER with ASM.

Using DBMS_FILE_TRANSFER with ASM.

Posted in Oracle, PLSQL | Tagged , | Comments Off

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 , , , , | 4 Comments