Guest User

Untitled

a guest
Dec 12th, 2018
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.44 KB | None | 0 0
  1. if (p_newcaps = 'Y') then
  2. p_newcapsdesc := 'Yes';
  3. elsif (p_newcaps = 'N') then
  4. p_newcapsdesc := 'No';
  5. else p_newcapsdesc := 'Keep';
  6. end if;
  7. if (p_newwkp = 'Y') then
  8. p_newwkpdesc := 'Yes';
  9. elsif (p_newwkp = 'N') then
  10. p_newwkpdesc := 'No';
  11. else p_newwkpdesc := 'Keep';
  12. end if;
  13. if (p_newunsch = 'Y') then
  14. p_newunschdesc := 'Yes';
  15. elsif (p_newunsch = 'N') then
  16. p_newunschdesc := 'No';
  17. else p_newunschdesc := 'Keep';
  18. end if;
Add Comment
Please, Sign In to add comment