Answer / kart

create or replace trigger trig_aone
before insert or update or delete on aone
for each row
begin
if to_char(sysdate,'HH24') not between (9) and (18) then
raise_application_error('-20011','u cant update in business
time');
end if;
end;

Answer / hari

We have to create trigger

create trigger trg_name
before insert/delete/update on table
when sysdate between 10am to 6pm
begin
logic
end;

Answer / pariksheet de

Grant Insert,Update,Delete
On Employees
To All

-----------------------------------------------

Create Trigger Upd_Employees
Before Insert,Update,Delete on Employees
For Each Row
Begin
if to_char(sysdate,'Dy') in
('Mon','Tues','Wed','Thrs','Fri','Sat','Sun') and to_char
(sysdate,'hr:mi') not between ('10:00') and ('6:00')
then raise_application_error(-
20145,'Insertion/Updation/Deletion can take place between
10:00 am and 6:00);
end if;
end;

Answer / cm

create one user in your windows o/s. Add this user into
your sql user in security.
This windows user provide the permission only 10am to 6pm.

Is sql low level language?

0 Answers  

---

Which type of cursor is used to execute the dml statement?

0 Answers  

---

What is union and union all keyword in sql?

0 Answers  

---

What steps server process has to take to execute an update statement?

0 Answers  

---

What are Anti joins

1 Answers   IBM,

---

what is an alias command? : Sql dba

0 Answers  

---

Hi Guys, I have a situation where I need to access the column values from rowtype variable. However, the column names are dynamic. below is sample code: declare Cursor c1 is select * from emp; Cursor c2 is select column_name from xyztable; v_c2 c2%rowtype; v_str varchar2 v_value varchar2(200); begin for rec in c1 loop open c2;---this cursor has column names like EMPLOYEE_ID, FIRST_NAME, LAST_NAME etc. loop fetch c2 into v_c2; exit when c2%notfound; /* now lets say i want to access value of LAST_NAME from cursor c1, so I am writing below code, however it does not work as expected */ v_str:= 'rec.'|| v_c2.column_name; -- this will give me string like "rec.EMPLOYEE_ID" v_value:=v_str; end loop; end loop; end; / Plz help ASAP.Thanks.

2 Answers  

---

Can a composite key be null?

0 Answers  

---

What are the events on which a database trigger can be based?

0 Answers  

---

I want to know the difference between A Record Type and a Table.

3 Answers   Thermotech,

---

what is a composite key ? : Sql dba

0 Answers  

---

What is data control language (dcl)?

0 Answers  

---