Create a table with only scale specification for a column

Hi All, Just came across a peculiar way of specifying only the column scale and not its precision, so thought of sharing with all. It looks pretty simple but could be a handy tip for table designs. Scenario: Create a table CONT_EMPS where Salary column must store values upto 2 places of decimals (i.e. scale … Continue reading »