Wednesday, June 27, 2018

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) COMP_TO_DEPT_NAME,
   C.COMP_TO_EMP_NO,
   C.LOC_ROOM_NO, C.LOC_DEPT_NO, C.LOC_DESC,
   C.COMP_BY, C.COMP_BYDEPT_NM, C.COMP_DTTM,
   C.IDENTIFIED_BY, C.IDENTIFIED_DTTM, C.IDENTIFIED_BYDEPT_NO,
   DECODE(C.VERIFY_FLAG,  'Y', 'P', 'O') VERIFY_FLAG,
   C.VERIFY_DTTM, C.VERIFIED_BY,
   DECODE(C.VALID_FLAG,  'Y', 'P', 'O') VALID_FLAG,
   DECODE(C.SOLVE_FG,  'Y', 'P', 'O') SOLVE_FG, 
   DECODE(C.DECI_FG,  'Y', 'P', 'O') DECI_FG,
   C.ACTION_FG, C.VERIFY_COMMENT, C.COMPANY_NO
FROM CMV_COMPLAIN C

---
then just take filed font ~ windings(western)2 and enjoy it.

Screen short :

Related Posts:

  • 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,   &… Read More
  • Sql Query: Count duplicate value 1. SELECT REG_NO, COUNT(REG_NO)  FROM OP_APPOINTMENT WHERE APPOINT_DATE BETWEEN NVL(:P_DT1,APPOINT_DATE) AND NVL(:P_DT2,APPOINT_DATE) GROUP BY REG_NO HAVING ( COUNT(REG_NO) > 1 ) 2. select PO… Read More
  • Trigger in oracle forms All lINK : 1. http://www.123techguru.com/types-of-controls/ Built_in sub programs used in Form Triggers . 1 commit_form used to save changes ( Valid for DML ) 2 clear_form clears all the blocks in form and place t… Read More
  • SQL: ## Used for show table name whose column name is user input : SELECT TABLE_NAME FROM USER_TAB_COLUMNS WHERE UPPER(COLUMN_NAME)='COLUMN_NAME'      Sub query : select  appoint_date,doc_name,doctor_no,doc… Read More
  • For Loop : Example : In this example used a pakage pkg_mm.prcinsitemstk <<Pakage>> <<Procedure>>  PROCEDURE prc_insitemstk (       p_column_name   IN   VARCHAR2, &n… Read More

0 comments:

Post a Comment