Boolean data type size and want to print its value?

Posted by Vineet on Stack Overflow See other posts from Stack Overflow or by Vineet
Published on 2010-04-03T04:43:01Z Indexed on 2010/04/03 4:53 UTC
Read the original article Hit count: 320

Filed under:

I want to know data data type of boolean , i used VSIZE() function but it is not working for boolean and Want to print and store boolean value into table. Please let me know how oracle store boolean value ,is there any other way to see data type and value for boolean variable. ERROR " expression is of wrong type" DECLARE a boolean; b number(7):=7; c number(2):=2; BEGIN a:=b>c; select vsize(a) into b from dual; dbms_output.put_line(b); END;

© Stack Overflow or respective owner

Related posts about oracle9i