To show  and tik mark and croos mark in oracle report; 1. first try to keep value for tik mark P and for cross mark O  for help try as following query : SELECT C.COMP_NO, C.COMP_DT, C.COMP_PRIORITY,    C.COMP_PRIORITY_NM, C.COMPLAIN_FOR, C.COMP_FOR_NM,    C.FOR_REF_NO, C.COMP_4REF_NM, C.COMP_DSCP,    C.PRIMARY_ACT, C.COMP_TO_DEPT_NO,    (SELECT DEPT_NAME FROM HR_DEPT WHERE DEPT_NO = C.COMP_TO_DEPT_NO)...

Read More

Trigger used in forms :

Type : User defined.           Oracle provided. go_field('adm_rec_amount');----same block so no need prefix. --- KEY-NEXT-ITME : This trigger can use procedure(user defined) like prc_search procedure  ; Example : PROCEDURE prc_search IS   V_DW_NEW VARCHAR2(4000); BEGIN   V_DW_NEW :=GET_BLOCK_PROPERTY('EMV_COMPLAIN',DEFAULT_WHERE);   V_DW_NEW := 'company_no = :global.g_company_no'; IF :ctrl_blk.complain_src...

Read More

Query Optimization

Link youtube to learn :   ##   Oracle Advanced SQL Optimization Techniques         blogs.oracle.com Cursor for loop : SELECT-INTO SELECT-INTO offers the fastest and simplest way to fetch a single row from a SELECT statement. The syntax of this statement is SELECT select_list INTO variable_list FROM remainder_of_query; where remainder_of_query contains the list of tables or views, the WHERE clause, and other clauses of the query. The number and types of elements in the variable_list must...

Read More