Interested to Buy Any Domain ? << Click Here >> for more details...
Practice 1: Changes to data will only be allowed on tables
during normal office hours of 8.45 in the morning until
5.30 in the afternoon, MONDAY through FRIDAY.
A. Create a procedure called SECURE_DML that prevents the
DML statement from executing outside of normal office
hours, returning the message:
“you may only make changes during normal office hours”
b. Create a statement trigger on the PRODUCT table which
calls the above procedure.
c. Test it by inserting a new record in the PRODUCT table.
- 1 Answers
- 11777 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / narenkumar reddy
create or replace
procedure SECURE_DML
is
begin
if to_char(sysdate,'h24:mi') not between '08:30' and '17:30' and
to_char(sysdate,'day') not between 'MONDAY' and 'FRIDAY' then
raise_application_error(-20001,'you may only make changes during normal
office hours');
end if;
end;
create or replace
trigger trigger_name
before insert or update or delete on PRODUCT
begin
SECURE_DML( );
end;
| Is This Answer Correct ? | 22 Yes | 3 No |
Post New Answer View All Answers
what are properties of a transaction? : Sql dba
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
What is an exception in PL/SQL? What are the two types of exceptions?
What is the requirement of self-join?
Why is pl sql needed?
What is the example of procedure?
What is blind sql injection?
tell me about various levels of constraint. : Sql dba
Explain character-manipulation functions?
What is the use of pl/sql table?
Does sql profiler affect performance?
what does the t-sql command ident_current does? : Transact sql
What is the location of pre_defined_functions.
Can a trigger call a stored procedure?
What is trigger explain it?
