SELECT upper('john jacb jingle ') "cap" , lower('john jacb jingle ')"lower" from dual

PostgereSQL:

SELECT upper('john jacb jingle ') "cap" , lower('john jacb jingle ')"lower"