Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT (CASE WHEN cv_lodged = 1
- THEN 'Yes'
- ELSE 'No'
- END) cv_lodged,
- other_columns
- FROM students
- CREATE FUNCTION my_bool_to_str( p_num IN NUMBER )
- RETURN VARCHAR2
- IS
- BEGIN
- IF( p_num = 1 )
- THEN
- RETURN 'Yes';
- ELSE
- RETURN 'No';
- END IF;
- END;
- SELECT my_bool_to_str( cv_lodged ) cv_lodged,
- other_columns
- FROM students
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement