Sunday, July 1, 2018

Triks for oracle

To assign search text in search box :
<>:CTRL_BLK.COMPLAIN_SRC:='<<Search Complain>>';
To assing item record sl. no:
use post query trigger block level:
<>:EMV_COMPLAIN.sl :=:system.trigger_record;

Related Posts:

  • 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
  • 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
  • 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
  • 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
  • Procedure : A procedure does not have a return type and should not return any value but it can have a return statement that simply stops its execution and returns to the caller. A procedure is used to return multiple values otherwise it… Read More

0 comments:

Post a Comment