How to declare a variable with FLOAT (2 DECIMAL PLACES) in table creation in oracle?

shivigupta
Profile Answers by shivigupta Questions by shivigupta
Oct 11th, 2012
3
3936

Questions by shivigupta answers by shivigupta

Showing Answers 1 - 3 of 3 Answers

Abhirup Roy

Oct 27th, 2015

In PL/SQL, unlike other programming language like C, we do not have a FLOAT data type. Instead we have NUMBER(precision,scale) data type, which can be used for both INTEGER and FLOATING NUMBERS. However we do separately have integer and pls_integer for specific integer usage. But for normal variable which is expected to retain a float value can be defined by NUMBER data type.