Click here to Skip to main content
15,902,905 members

Comments by MukeshSagar (Top 21 by date)

MukeshSagar 30-Oct-14 7:31am View    
refer the link :
http://stackoverflow.com/questions/18181909/count-the-number-of-checkboxlist-and-if-checked-items-more-than-1-check-another
MukeshSagar 30-Oct-14 7:29am View    
Use JQuery code to check the number of selected checked boxes
MukeshSagar 22-Oct-14 2:47am View    
No this is the key on the basis of which the data is encrypted
MukeshSagar 18-Oct-14 8:05am View    
Create log table:

DROP TABLE Emp_log;
CREATE TABLE Emp_log (
Emp_id NUMBER,
Log_date DATE,
New_salary NUMBER,
Action VARCHAR2(20));

Create trigger that inserts row in log table after EMPLOYEES.SALARY is updated:

CREATE OR REPLACE TRIGGER log_salary_increase
AFTER UPDATE OF salary ON employees
FOR EACH ROW
BEGIN
INSERT INTO Emp_log (Emp_id, Log_date, New_salary, Action)
VALUES (:NEW.employee_id, SYSDATE, :NEW.salary, 'New Salary');
END;
/
Update EMPLOYEES.SALARY:

UPDATE employees
SET salary = salary + 1000.0
WHERE Department_id = 20;

Result:

2 rows updated.

Show log table:

SELECT * FROM Emp_log;

Result:

EMP_ID LOG_DATE NEW_SALARY ACTION
---------- --------- ---------- --------------------
201 28-APR-10 15049.13 New Salary
202 28-APR-10 6945.75 New Salary

2 rows selected.
MukeshSagar 17-Oct-14 7:49am View    
Show the screen shot of the output, so that i can suggest solution