About Oracle and Oracle ā'pěks (#orclapex)

Objective : To generate excel (csv) file in Oracle Directory using Oracle PL/SQL. Scenario : Customer asks us to generate excel report in oracle directory itself; from there customer will download the report. The report should be in the format of CSV. Solution : Step 1:  Call the PL/SQL procedure to generate excel (CSV) report in oracle directory. Step 2:  Procedure P_GEN_EXCEL_CSV_REPORT_DIR. Conclusion:  This procedure will help us to generate Excel (CSV) file in oracle directory through PL/SQL.

Objective : To generate xls, xlsx file in Oracle Directory using Oracle PL/SQL. Scenario : Customer asks us to generate excel report in oracle directory itself; from there customer will download the report. The report should be in the format of xls (or) xlsx. Solution : Step 1:  Call the PL/SQL procedure to generate excel report in oracle directory. Step 2:  Procedure P_GEN_EXCEL_REPORT_DIR. Conclusion:  This procedure will help us to generate Excel (xls, xlsx) file in oracle directory through PL/SQL.

Objective : To generate Database File (DBF) in Oracle Directory using Oracle PL/SQL. Scenario : Customer asks us to generate database file format report in oracle directory itself; from there customer will download the report.  Solution : Step 1:  Call the PL/SQL procedure to generate DBF report in oracle directory. Step 2:  Package  sssl_dbase_pkg_clob. << Package Specification <> CREATE OR REPLACE PACKAGE sssl_dbase_pkg_clob AS   PROCEDURE load_table(       p_dir    IN VARCHAR2,       p_file   IN VARCHAR2,       p_tname  IN VARCHAR2,       p_cnames IN VARCHAR2 DEFAULT NULL,       p_show   IN boolean DEFAULT FALSE);   PROCEDURE dump_table(       p_dir          IN VARCHAR2,       p_file         IN VARCHAR2, ...