Oracle Application Blog

Generate csv file in Oracle Directory Using Oracle PL/SQL

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…

Read More

Generate DBF file in Oracle Directory Using Oracle 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…

Read More

Data template in Oracle BI Publisher 10g

Objective: To generate reports from OBIP using data template SQL queries. Scenario: Customer has given a requirement to develop the report in OBIP. While developing it, developer came to know…

Read More

Scroll to the top of the page/report in Oracle APEX

Objective: To Scroll the top of the page/report in Oracle APEX application. Scenario: We have encountered an issue that you always stay on the bottom of the page even after…

Read More

APEX Reports with dynamic help text in Oracle APEX 4.2 using CSS

Objective: To show dynamic help text in APEX reports (Interactive/classical) in Oracle APEX 4.2 using CSS. Solution: Step 1: Create Interactive report Step 2: Use below query in IR Region…

Read More

Generate DDL source code using Oracle SQL

Objective: To generate DDL source code using Oracle SQL. Scenario: Customer asks us to generate all the DDL source code for some database objects. So I just found the little…

Read More

Split by count excel report in Oracle BI Publisher 10g

Objective: To create a template to split records in excel sheet in Oracle BI Publisher 10g. Solution: Template Creation – EXCEL Step 1: Open the Excel. (See below image) Step…

Read More

Stop the user to click a page submit button more than once in Oracle APEX 4.2

Objective: To stop the user to click a APEX page submit button more than once in Oracle APEX 4.2 Scenario: The standard way to push the page data back to…

Read More

Call Oracle package in Oracle BI Publisher 10g

Objective: To call Oracle package in Oracle BI Publisher 10g. Scenario: Oracle BI Publisher is just a reporting tool. From which we can download excel, csv, xml, rtf, PDF reports.…

Read More

Suppliers Report (XML)DescriptionSuppliersReport

Suppliers Report (XML) Description Suppliers Report (XML) is used to review the supplier, supplier site and supplier contacts details. 1. Query Fetching Vendor Details: SELECT p.vendor_id c_vendor_id, p.segment1 c_vendor_number,       …

Read More