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
- 11195 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
Explain the the update statement in sql?
What are conditional predicates?
Is foreign key mandatory?
What is the difference between database trigger and stored procedure?
What makes a good primary key?
What does seeding a database mean?
Write a sql query to find the names of employees that begin with ‘a’?
What is raid? How does it help storage of databases?
What is data definition language?
Why coalesce is used in sql?
Explain the order of sql statement execution?
What is data profiling in sql?
What is cursor explain with example?
How do I filter in sql profiler?
Why do we use sql constraints? Which constraints we can use while creating database in sql?
