update statement....problem
733256Nov 11 2009 — edited Nov 11 2009+1 select id,substr(name,1,10),deptid,dept,join_date+
+2* from student+
SQL> /
ID NAME DEPTID DEPT JOIN_DATE
---------- ---------- ---------- ---------- ----------
a101 abc 23 20-OCT-09
a102 ijk 5 20-OCT-09
a103 dfdgf 3 20-OCT-09
a104 werr 5 20-OCT-09
a105 asd
a106 LLLL 4
a107 mno 4
SQL> select * from department;
DEPTID DEPTNAME
---------- --------------------
+1 mining+
+2 systems+
+3 excavation+
+4 civil+
+5 mechanical+
+6 CIVIL+
+23 DFG+
i want to update dept column on student table...using a query....all rows are update according to there deptid (mean student.deptid=department.deptid)...*with out using merge statement or procedure*.....