Advertisement
Guest User

Untitled

a guest
Oct 24th, 2014
124
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.39 KB | None | 0 0
  1. SELECT (CASE WHEN cv_lodged = 1
  2. THEN 'Yes'
  3. ELSE 'No'
  4. END) cv_lodged,
  5. other_columns
  6. FROM students
  7.  
  8. CREATE FUNCTION my_bool_to_str( p_num IN NUMBER )
  9. RETURN VARCHAR2
  10. IS
  11. BEGIN
  12. IF( p_num = 1 )
  13. THEN
  14. RETURN 'Yes';
  15. ELSE
  16. RETURN 'No';
  17. END IF;
  18. END;
  19.  
  20. SELECT my_bool_to_str( cv_lodged ) cv_lodged,
  21. other_columns
  22. FROM students
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement