Wednesday, January 17, 2007

SQL – Update

Example :

update emp

set sal = sal*2.25

where deptno = 30

update emp

set sal = sal*2.25

where empno in ( select empno from emp_1 )


Comments: Post a Comment

Subscribe to Post Comments [Atom]





<< Home

This page is powered by Blogger. Isn't yours?


SQL PL/SQL Blog   QTP Blog   PL SQL   SQL Tutorials   PL/SQL Tutorials   Apple iphone Blog