Answer Posted / debasish sinha

create or replace trigger trg_sun
before insert on <table name>
begin
if rtrim(to_char(sysdate,'day'))=rtrim('sunday') then
raise_application_error(-20345,'no transaction in sunday');
end if;
end trg_sun;

Mention what plvcmt and plvrb does in pl/sql?

1073

---

Why do we use procedures in pl sql?

981

---

What are conditional predicates?

1005

---

How does sql*loader handles newline characters in a record? : aql loader

1004

---

What is the use of <> sql?

941

---

Does varchar need length?

948

---

Where is all the data on the internet stored?

960

---

Explain correlated query work?

1002

---

What is the maximum database size for sql express?

983

---

what is the command line end user interface - mysql? : Sql dba

939

---

what is normalization? : Sql dba

1038

---

Can a key be both primary and foreign?

954

---

What are the benefits of pl sql?

1074

---

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

1798

---

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

1168

---