Query to generate Baseline Script for a SQL_ID in Oracle Database
Please use the below query. col sql_text for a60 wrap set verify off set pagesize 999 set lines 155 col username format a13 col prog format a22 col sid format…
Read MoreMultiple sheet excel report template generation in Oracle BI Publisher 10g
Objective: To create template for generating multiple sheet excel in Oracle BI Publisher 10g. Solution: Template Creation – EXCEL Step 1: Excel contains the below template with Sheet1 and 2…
Read MoreMultiple sheet excel report in Oracle BI Publisher 10g using data template SQL Query
Objective: To generate multiple excel sheet report from OBIP using data template SQL queries. Scenario: Customer needs multiple sheets excel report from OBIP. While developing it, developer came to know…
Read MoreData 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 MoreGenerate 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 MoreSplit 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 MoreCall 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 MoreCalculate PO Balances
— Query to retrieve customer PO details SELECT obha.order_number, obha.sold_to_org_id, obha.cust_po_number, obha.header_id, obha.org_id, TO_DATE (obha.attribute16,’YYYY/MM/DD HH24:MI:SS’) po_last_calc_date, …
Read More