Update

Next message: Hugo Kornelis: "Re: Update"
Previous message: Hari Prasad: "Re: Append Data"
Next in thread: Hugo Kornelis: "Re: Update"
Reply: Hugo Kornelis: "Re: Update"
Messages sorted by: [ date ] [ thread ]

From: mottu (anonymous_at_discussions.microsoft.com)
Date: 07/29/04

Date: Thu, 29 Jul 2004 04:22:06 -0700

I've Emp table with empno, name, dept. The data for the
dept are A,B,C

I want to update that table Edu for A, Sport for B,....
using self join in single statement.

is it possible?

Regs,
Mottu

Relevant Pages

Re: Generating SQL
... insert into emp (empno, ename) ... application developers have to rewrite any sql statements whenever db ...
(comp.object)
Re: Help - "Business Day" Problem
... | from emp where empno =:1) ... Predicate Information: ... where empno =:emp; ... if dummy> 0 then ...
(comp.databases.oracle.misc)
Re: Help - "Business Day" Problem
... |>Predicate Information: ... | from emp ... | if dummy> 0 then ... | where empno =: emp; ...
(comp.databases.oracle.misc)
Re: ORA-01756: quoted string not properly terminated
... end loop; ... I have following data in emp table ... empno 1,2 and 3 are inserted properly. ...
(comp.databases.oracle.server)
Re: ORA-01756: quoted string not properly terminated
... end loop; ... I have following data in emp table ... empno 1,2 and 3 are inserted properly. ... i.e. when Cursor contains the value as D'Costa. ...
(comp.databases.oracle.server)