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

What is a sql instance vs database?

578

---

what is 'mysqladmin' in mysql? : Sql dba

534

---

what are numeric data types? : Sql dba

580

---

How much does sql cost?

522

---

What is faster join or subquery?

512

---

---

what are myisam tables? : Sql dba

552

---

How to display the records between two range in Oracle SQL Plus?

641

---

What are tables and fields?

593

---

what is recursive stored procedure? : Sql dba

529

---

what is index? : Sql dba

558

---

How do I pipe the output of one isql to another?

532

---

Can you load data into multiple tables at once? : aql loader

604

---

Does truncate table reset auto increment?

528

---

What is a mutating table and a constraining table?

575

---

What is the difference between the conventional and direct path loads? : aql loader

695

---