Archive for 2015
Following PL/SQL block will help you to export or download table data directly in your browser with .xsl format (workbook with multiple sheets or tabs).
As shown below :
declare
l_clob...
Below PL/SQL Block will help you to download file from specific directory path to your browser.
First you need to register the directory path of file with oracle using below syntax.
CREATE...
Following PL/SQL Block generates workbook (.xsl) file with two worksheet's named as Employees and Customers containing detail level data about employee and customer.
By using below...
Start with iReport :
1.Download and install iReport version 4.6.0
2.Load required .jar file (ex. ojdbc14 driver for oracle database) using below navigation.
...
Consider below IR report:
I want to highlight only those
rows whose LOB’s value is ERP.
Create dynamic action:
Name: Highlight based on LOB/Department Column
Event: After Refresh
Selection...
SET SERVEROUTPUT ON;
DECLARE
V1 VARCHAR2(32767);
l_file UTL_FILE.FILE_TYPE;
V_COUNT NUMBER :=0;
V_FILENAME VARCHAR2(50):=NULL;
l_buffer...
In iReport to pass parameter from Main report to Dataset use following steps:
1. Create parameter in main report section.
2. Set parameter properties accordingly.
3. Add new dataset by right...
Below error occurs because there is no any data to show
on report.
If you are using the Detail Bandeport, then you will need a
Data Query for the report. Since it's returning "No Pages" in
iReport,...
UTL_FILE is an oracle pl/sql package that is supplied to allow PL/SQL to read and create text files in the file system.
UTL_FILE can only read and create text files. Specifically, it cannot be used...
Types of Views
Simple View
Complex View
Materialized View
Force View
Simple View ...
- Simple View is the view that is created based on a single table
- Derives data...
What is View?
A view is a named and validated SQL query which is stored in the Oracle data dictionary.
View does not have storage of its own (i.e. View does not hold any data) .
It is just a stored...
