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...
Sunday, November 20, 2016
Saturday, November 19, 2016
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. Query:...
ORACLE REPORTS PERFORMANCE TIPS
Doc ID 61535.1Performing operations in SQL may be faster than performing them in OracleReports or PL/SQL. The list below explains the most common cases where usingSQL 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 trigger to...
Using SRW Packaged Procedures in Reports
Oracle Reports is shipped with a collection of PL/SQL constructs that containmany 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). SRW...
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 the...
SQL Commands
SQL COMMANDSCREATE COMMANDSCreate TableCREATE 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...
