Suresh*** wrote:Yes, you can see I've already been corrected and acknowledged that correction.
Thanks For all your Reply which helps me in learning ....this below code works fine
Your saying there is no BOOLEAN data type in oracle
But in the text book Oracle 9i
I found Base scalar data type -- char , varchar2, long ,long Ram, Number, Binary_Interger,pls_integer,BOOLEAN
And this Example I found in Chapter 4 - Control structureI don't understand your question.
And One more doubt
Here i have passed like this ... v_Hire_date date :='12-Dec-2005';
I learnt Date and Char must be passed with single quotation in the book also they have passed with single quotes?
Please advice me
DECLARE v_Hire_date date :=to_date ('12-Dec-2010','DD-MON-YYYY'); v_five_years BOOLEAN; BEGIN IF Months_between(sysdate,v_Hire_date)/12 > 5 then v_five_years := True; ELSE v_five_years := False; END IF; --Dbms_output.put_line (v_five_years); dbms_output.put_line(CASE WHEN v_five_years THEN 'True' ELSE 'False' END); --dbms_output.put_line( sys.dbms_sqltcb_internal.i_convert_from_boolean(v_five_years)); END;