Wednesday, September 5, 2018
Friday, August 17, 2018
Monday, August 13, 2018
Trigger
4:32 PM
No comments
$$ 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
SELECT MAX (view_sl) + 1
INTO sl
FROM op_patdisplay
WHERE tvdisplay_id = 1;
INSERT INTO op_patdisplay
(room_name, movement_type_no, room_no, view_sl,
show_fg, view_page, tvdisplay_id, check_inout
)
VALUES (:NEW.room_name, '5', :NEW.room_no, sl,
'1', '1', '1', '0'
);
END;
ELSIF :NEW.occupancy_service = 'E'
THEN
DECLARE
sl NUMBER (3);
BEGIN
SELECT MAX (view_sl) + 1
INTO sl
FROM op_patdisplay
WHERE tvdisplay_id = 3;
INSERT INTO op_patdisplay
(room_name, movement_type_no, room_no, view_sl,
show_fg, view_page, tvdisplay_id, check_inout
)
VALUES (:NEW.room_name, '5', :NEW.room_no, sl,
'1', '1', '3', '0'
);
END;
ELSIF :NEW.occupancy_service = 'D'
THEN
DECLARE
sl NUMBER (3);
BEGIN
SELECT MAX (view_sl) + 1
INTO sl
FROM op_patdisplay
WHERE tvdisplay_id = 2;
INSERT INTO op_patdisplay
(room_name, movement_type_no, room_no, view_sl,
show_fg, view_page, tvdisplay_id, check_inout
)
VALUES (:NEW.room_name, '5', :NEW.room_no, sl,
'1', '1', '2', '0'
);
END;
END IF;
END IF;
EXCEPTION
WHEN OTHERS
THEN
NULL;
END;
/
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
SELECT MAX (view_sl) + 1
INTO sl
FROM op_patdisplay
WHERE tvdisplay_id = 1;
INSERT INTO op_patdisplay
(room_name, movement_type_no, room_no, view_sl,
show_fg, view_page, tvdisplay_id, check_inout
)
VALUES (:NEW.room_name, '5', :NEW.room_no, sl,
'1', '1', '1', '0'
);
END;
ELSIF :NEW.occupancy_service = 'E'
THEN
DECLARE
sl NUMBER (3);
BEGIN
SELECT MAX (view_sl) + 1
INTO sl
FROM op_patdisplay
WHERE tvdisplay_id = 3;
INSERT INTO op_patdisplay
(room_name, movement_type_no, room_no, view_sl,
show_fg, view_page, tvdisplay_id, check_inout
)
VALUES (:NEW.room_name, '5', :NEW.room_no, sl,
'1', '1', '3', '0'
);
END;
ELSIF :NEW.occupancy_service = 'D'
THEN
DECLARE
sl NUMBER (3);
BEGIN
SELECT MAX (view_sl) + 1
INTO sl
FROM op_patdisplay
WHERE tvdisplay_id = 2;
INSERT INTO op_patdisplay
(room_name, movement_type_no, room_no, view_sl,
show_fg, view_page, tvdisplay_id, check_inout
)
VALUES (:NEW.room_name, '5', :NEW.room_no, sl,
'1', '1', '2', '0'
);
END;
END IF;
END IF;
EXCEPTION
WHEN OTHERS
THEN
NULL;
END;
/
Thursday, August 9, 2018
Tuesday, July 31, 2018
Computer Basic
6:17 PM
No comments
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 calculations
Time in Dhaka 
