hi there
im new in oracle, i want to edit/update table ( emp ) , how can it done.
thnk
You need to write some SQL that will UPDATE the records in the table.
Do not forget to commit the transactions (using COMMIT command).
can u plz write for me
thaks
Sorry, I don't do that.
thank you
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.
Update Emp
Set Sal = sal + 1000
where empno = 102
update emp
set emp_id= 160
where emp_id= 120
insert into emp
values(..,..,..)
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.