...
Friday, December 28, 2018
Wednesday, September 19, 2018
Sunday, September 16, 2018
logon page center window.
Call procedure in when new form instance
CENTER_FORM('WINDOW1',0);
PROCEDURE CENTER_FORM(MyWindowName IN varchar2,UpperMargin IN number) IS
x number(6);
y number(6);
BEGIN
SET_WINDOW_PROPERTY(FORMS_MDI_WINDOW,TITLE,'India');
Set_window_property(forms_mdi_window,window_state,maximize);
x:=((get_window_property(forms_mdi_window,width)-get_window_property(MyWindowName ,width))/2);
y:=((get_window_property(forms_mdi_window,height)-get_window_property(MyWindowName ,height))/2+UpperMargin);
set_window_property(MyWindowName , position,x,y);
...
Wednesday, September 5, 2018
Friday, August 17, 2018
Monday, August 13, 2018
Trigger
$$ Trigger with use when condition $$
CREATE OR REPLACE TRIGGER trg_hpms_room
AFTER INSERT OR UPDATE
ON hpms_room
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
WHEN (NEW.occupancy_service IN ('E', 'C', 'D'))
BEGIN
IF INSERTING
THEN
IF :NEW.occupancy_service = 'C'
THEN
DECLARE
sl NUMBER (3);
BEGIN
...
Thursday, August 9, 2018
Tuesday, July 31, 2018
Computer Basic
ALU: An arithmetic logic unit (ALU) is a digital
circuit used to perform arithmetic and logic operations.It represents the
fundamental building block of the central processing unit (CPU) of a computer.
Modern CPUs contain very powerful and complex ALUs. The purpose of the
ALU is to perform mathematical operations such as addition, subtraction,
multiplication and division. Additionally, the ALU
processes basic logical operations like AND/OR calculatio...
Friday, July 27, 2018
Tuesday, July 24, 2018
Sunday, July 15, 2018
Saturday, July 14, 2018
Wednesday, July 11, 2018
Tuesday, July 3, 2018
Software demo youtube link
1. https://www.youtube.com/watch?v=kIqWiRb_W9I
2. https://www.youtube.com/watch?v=UU6huYBUwOI
3. https://youtu.be/h-uLdDQIdZA
4. Prescription
5. HPMS SOFTWARE
6. OR Work Fl...
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_recor...
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)...
Monday, June 11, 2018
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...
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...
Thursday, May 31, 2018
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 the cursor in first block
3 clear_block clears the current block
4 clear_record clears the current record
5 clear_item clears the current text item
6 exit_form quits the application
7 next_block moves to the next block
8 previous_block...
Time in Dhaka 
