Practice 1: Changes to data will only be allowed on tables during normal offic

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.

Question Posted / ashok

1 Answers
11754 Views
Tech Mahindra, I also Faced
E-Mail Answers

Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in t..

Answer / 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

More SQL PLSQL Interview Questions

Why do we use procedures in pl sql?

0 Answers

In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both loops can do the same task) 1) open - Fetch loop 2) for loop

4 Answers JDA,

What is pl/sql and what is it used for?

4 Answers

What is union?

0 Answers

What is the diffrence between IN and EXISTS.which one is faster.

3 Answers Infogain,

What is the primary key?

0 Answers

What are all types of user defined functions?

0 Answers

What is data type in database?

0 Answers

What is scalar data type in pl sql?

0 Answers

Explain the working of primary key?

0 Answers

how to check the 3rd max salary from an employee table? One of the queries used is as follows: select sal from emp a where 3=(select count(distinct(sal)) from emp b where a.sal<=b.sal). Here in the sub query "select count(distinct(sal)) from emp b where a.sal<=b.sal" or "select count(distinct(sal)) from emp b where a.sal=b.sal" should reveal the same number of rows is in't it? Can any one here please explain me how is this query working perfectly. However, there is another query to get the 3rd highest of salaries of employees that logic I can understand. Pls find the query below. "select min(salary) from emp where salary in(select distinct top 3 salary from emp order by salary desc)" Please explain me how "select sal from emp a where 3=(select count(distinct(sal)) from emp b where a.sal<=b.sal)" works source:http://www.allinterview.com/showanswers/33264.html. Thanks in advance Regards, Karthik.

4 Answers

wt is the diff b/w greast and max ,least and min? wt is the diff b/w case and decod?

4 Answers Oracle, TCS, Tecnics,

For more SQL PLSQL Interview Questions Click Here