Advertisement
Shailrshah

Trigger for Converting Customer's Name to Upper Case

Oct 27th, 2013
168
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.17 KB | None | 0 0
  1. CREATE OR REPLACE TRIGGER upCase BEFORE INSERT OR UPDATE ON cust FOR each ROW
  2. DECLARE
  3. BEGIN
  4. :NEW.lname := UPPER(:NEW.lname);
  5. :NEW.fname := UPPER(:NEW.fname);
  6. END;
  7. /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement