SELECT ENAME, SAL, SAL * .15
FROM EMP
WHERE JOB='CLERK';
Note the new column name
| SQL_multiply_Operator |
Objective : multiplication
|
| Compare between PostgreSQL and Oracle |
|
| pOSTGRESQL :
|
| Oracle:
Note the new column name
|
| The image on the left was a screen shot from PostgreSQL, where 3rd
column-name display was undefined, where Oracle shows the formula
" SAL * .25 " as a column name.
|