Notastrophe
Oracle and Java and stuff.
Tuesday, 19 March 2013
Oracle PL/SQL Convert BOOLEAN to STRING
In Oracle pl/sql there is no direct method to convert a boolean type to a character type. It is necessary to test the boolean with a case statement as below:
l_varchar := case l_bool when TRUE then 'TRUE' else 'FALSE' end;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment