hello,
I’m using Oracle 10gR2 and i want to know what’s the differences between both because I take a look at the documentation and i find out there no differences.
any suggestions will be appreciated.
Question
Share
Sign Up to our social questions and Answers to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers to ask questions, answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
hello,
I’m using Oracle 10gR2 and i want to know what’s the differences between both because I take a look at the documentation and i find out there no differences.
any suggestions will be appreciated.
Hi,
binary_integerandpls_integerboth are same. Both are PL/SQL datatypes with range -2,147,648,467 to 2,147,648,467.Compared to
integerandbinary_integerpls_integervery fast in excution. Becausepls_intgeroperates on machine arithmetic andbinary_integeroperes on library arithmetic.pls_integercomes from oracle10g.binary_integerallows indexing integer for assocative arrays prior to oracle9i.