I already have a table whose name is EMP_DETAILS. It has 3 column, one is NAME (VARCHAR2(150)), EMP_ID(NUMBERS(5,0)) and another one is SALARY(INTEGER(5,0)). I want to alter the datatype of column SALARY to FLOAT.
Primary Key is EMP_ID.
For that t wrote a query which is, ALTER TABLE EMP_DETAILS MODIFY SALARY float(5,0);
When ever I want to insert some value into this table I didn't insert any value into this.
Actually I want to Know what is the syntax to get the float value.