Tools to Monitor Linux PerformanceLinux How to Close and Open Ports with iptables How to Reset "root" Password with GRUB on Enterprise Linux Forcefully unmount a Linux disk partition Get...
Validating Parameters in Oracle Reports using PL/SQL
Parameters
can be populated and validated using various srw pl/sql triggers.
The
following gives examples of:
Validation trigger in parameter spread sheet
Before parameter form trigger
After parameter form trigger
Before report trigger
Examples
of validation triggers on the property sheet for parameter PARAM_SAL. ...
ORACLE REPORTS PERFORMANCE TIPS
Doc ID 61535.1
Performing operations in SQL may be faster than performing them in Oracle
Reports or PL/SQL. The list below explains the most common cases where using
SQL would improve performance:
- perform calculations directly in your query rather than in a formula or
summary,
- use a WHERE clause instead of a group filter or format...
Using SRW Packaged Procedures in Reports
Oracle
Reports is shipped with a collection of PL/SQL constructs that contain
many
functions, procedures, and exceptions that you can reference in your
libraries
or reports. The name of Oracle Reports'
package is SRW. Therefore,
anytime
you reference a construct in the SRW package, you must prefix it with
SRW
(such as, SRW.DO_SQL)....
Running SQL*Trace on an Applications Report
There are two methods to running a Report with SQL*Trace which are:
Method #1: Normally, in order to run a report with SQL*Trace, you would have to do the following:
1. Turn SQL*Trace on by modifying your init.ora file.
2. Shut down the concurrent managers and the database.
3. Bring the database and...
SQL Commands
SQL COMMANDS
CREATE
COMMANDS
Create Table
CREATE TABEL EMP(empno number, ename varchar2(30), hiredate date);
CREATE TABLE scott.emp
(empno NUMBER CONSTRAINT pk_emp PRIMARY KEY,ename VARCHAR2(10) CONSTRAINT nn_ename NOT NULL CONSTRAINT upper_ename CHECK (ename = UPPER(ename)),job VARCHAR2(9),mgr NUMBER CONSTRAINT fk_mgr REFERENCES scott.emp(empno),hiredate...
