Skip to content
Advertisement

How to I create a new column in a table and add values to it

I have to create a new column in my table called Raise that has a 20% raise from the values of the SAL column, here’s what I have so far:

SELECT ENAME,EMPNO, JOB, SAL from emp
ALTER TABLE emp
ADD Raise (INTEGER)
ALTER TABLE emp
Raise=SAL+SAL*0.20

Im not too sure what Im doing wrong here

Advertisement

Answer

Assuming that you are using Oracle (because your table looks like EMP from the SCOTT schema), is this what you want?

alter table emp add raise number;
update emp set raise = sal * 1.2;

Note that if you want to increase something by 20%, then you probably want the result to be numeric rather than integer.

User contributions licensed under: CC BY-SA
3 People found this is helpful
Advertisement