OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » urgent

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

urgent [message #21280]

Wed, 24 July 2002 00:36

sha
Messages: 84
Registered: July 2002

Member

Hi,
I want to update the table as null values based on primary key.(i.e. no values in the record)
thanx in advance

Report message to a moderator

Re: urgent [message #21281 is a reply to message #21280]

Wed, 24 July 2002 01:02

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

update emp set comm = null where empno=3383;

Report message to a moderator

Re: urgent [message #21293 is a reply to message #21280]

Wed, 24 July 2002 21:23

sha
Messages: 84
Registered: July 2002

Member

Hi,
I want to update the all the fields of table not one field.
e.g.
update emp set ename='',sal='';
Is there a way instead of giving all field names as
ename='',sal='' so on
please tell me
thanx in advance

Report message to a moderator

Previous Topic:	Joins / substr / LIKE
Next Topic:	dblink

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 00:15:08 CDT 2024