Monthly Archives: gennaio 2014

ORACLE DATABASE 12C: New Features for Oracle Database File System
  • 28
    Gen

ORACLE DATABASE 12C: New Features for Oracle Database File System

Oracle Database File System (DBFS) was introduced in 11g R2 release on top of the XML DB (shortly, XDB) features. The concept is simple: DBFS is a tablespace whose contents are documents (specifically LOB columns) directly accessible (i.e. mounted) as an external file system. In Oracle 11g R2 the only way to do it is via FUSE (Filesystem...

Read More
A simple procedure for create a flat csv file from table
  • 20
    Gen

A simple procedure for create a flat csv file from table

Sometimes can be useful to produce a CSV file semicolon separated from a table. Here a simple dynamic procedure that works without write sql scripts pl sql code. Just put in some parameters and execute it from everywhere. With little customizations you can add a parameter for separator, add “” for strings, columns to avoid etc. CREATEORREPLACEprocedureTABLETOCSV( P_OWNERinvarchar2,--owner...

Read More
SQL DEVELOPER 4: NEW FEATURES FOR DBAS
  • 8
    Gen

SQL DEVELOPER 4: NEW FEATURES FOR DBAS

The new Oracle SQL Developer 4.0 (released on december 2013) has some great new features for DBAs, as it becomes the main administration platform instead of Oracle Enterprise Manager Database Control for Oracle Database 12c. OEM Database Control is actually disappeared in Oracle Database 12c, because it is substituted by: - Oracle Enterprise Manager Express, web-based basic administration...

Read More
AUTHID property
  • 3
    Gen

AUTHID property

The AUTHID property of a stored PLSQL unit, determines the authorization under which a PLSQL subprogram operates at run-time. You can use two clause:  . CURRENT_USER : when the subprogram is executed , it will run using the rights of the person that invoked the code, not with the creator's rights  . DEFINED : when the subprogram is...

Read More