update table

[hamoud]

hi there

im new in oracle, i want to edit/update table ( emp ) , how can it done.

thnk

[debasisdas]

You need to write some SQL that will UPDATE the records in the table.

Do not forget to commit the transactions (using COMMIT command).

[hamoud]

can u plz write for me
thaks

[debasisdas]

Sorry, I don't do that.

[hamoud]

thank you

[riju_sh02]

hi there

im new in oracle, i want to edit/update table ( emp ) , how can it done.

thnk

The command syntax is
Update Table <tablename>
Set<expression>
where <condition>

e.g
If u want to increase sal column for Emp table by 1000 then the command will be

Update Emp
Set Sal = sal + 1000

I hope tthis will help u.

[karant]

Update Emp
Set Sal = sal + 1000
where empno = 102

[darkdai]

update emp
set emp_id= 160
where emp_id= 120

insert into emp
values(..,..,..)