PERCENT IN SQL ORACLE

CAN I FORMAT A PERCENTAGE IN ORACLE?
I WOULD LIKE OPTION_PERCENTAGE TO BE ONLY DECIMAL PERCENTAGE.

I AM GETTING ERROR WITH NUMBER(0,2)

ANY IDEA?
THANKS!!
CREATE TABLE DRAWOP
  ( OPTION_NUMBER NUMBER(5,0)   
  , OPTION_TYPE VARCHAR2(1)
  , OPTION_DESCRIPTION VARCHAR2(20)
  , OPTION_UNIT_COST NUMBER(5,2)
  , OPTION_UNIT_PRICE NUMBER(5,2)
  , OPTION_PERCENTAGE NUMBER(0,2) 
  , CONSTRAINT OP_TYPE CHECK (OPTION_TYPE IN ('%', '$')));

Open in new window

ba_trainerAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Kevin CrossConnect With a Mentor Chief Technology OfficerCommented:
Think you WANT NUMBER(2, 2) for the format and then you can put a constraint that value is >= 0 and <= 1.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.