Another example of overriding the column default and formatting the output:
SELECT salary (FORMAT '$$$,$$9.99') FROM employee WHERE empno = 10019 ;
The system returns:
Salary ------ $28,600.00
Another example of overriding the column default and formatting the output:
SELECT salary (FORMAT '$$$,$$9.99') FROM employee WHERE empno = 10019 ;
The system returns:
Salary ------ $28,600.00