Answer Posted / rajdeep

create or replace trigger <trigger_name> before insert on <table_name>
begin
if (sysdate,'day') in 'sunday'
then
raise_application_error(-20500,'cannot insert values on sunday');
end if;
end;

What is an example of translating a date into julian format?

1201

---

How many types of index are there?

1098

---

Is sql a microsoft product?

994

---

Can we call a function containing dml statements in a select query?

1023

---

Can you sum a count in sql?

1059

---

Enlist the characteristics of pl/sql?

1842

---

What does count (*) do in sql?

1050

---

How do you explain an index number?

1184

---

Is sql microsoft?

1103

---

how to include character strings in sql statements? : Sql dba

1133

---

How many indexes can be created on a table in sql?

1110

---

Enlist some predefined exceptions?

1108

---

What is trigger types of trigger?

1140

---

How to display Row Number with Records in Oracle SQL Plus?

1092

---

Can you inner join the same table?

1036

---