Though the HAVING clause specifies a condition that is similar to the purpose of a WHERE clause, the two clauses are not interchangeable. Listed below are some differences to help distinguish between the two: 1. The WHERE clause specifies the criteria which individual records must meet to be selcted by a query. It can be… Read More »
PROCEDURE: CREATE OR REPLACE procedure_name(arg1 data_type, …) AS BEGIN …. END procedure_name; Example: CREATE OR REPLACE PROCEDURE ADD_EVALUATION ( evaluation_id IN NUMBER , employee_id IN NUMBER , evaluation_date IN DATE , job_id IN VARCHAR2 , manager_id IN NUMBER , department_id IN NUMBER ) AS BEGIN NULL; END ADD_EVALUATION; FUNCTION: CREATE OR REPLACE FUNCTION calculate_score (… Read More »
Stored Procedure Universe A stored procedure can be a used in a UNV universe and provides some performance improvement. The feature itself has many restrictions that should be considered before designing a universe with them. This is an explanation of this feature and some of the benefits and limits of its use. Since version XI3.1… Read More »
BIAR files are no longer used in BI4.x for the same purpose as we used them in Xi3.1. In BI4.x BIAR files can only be generated by UMT tool and can only be imported into next version of the product. We need to log into the CMS and use Promotion Manager which used to be called… Read More »