Home » SQL & PL/SQL » SQL & PL/SQL » updating a record
updating a record [message #21535] Sat, 10 August 2002 03:00 Go to next message
sha
Messages: 84
Registered: July 2002
Member
HI,
How can I update a complete record as null based on a primary key field.
Not like update emp set ename='',sal='' where empno=1
If I have 60 columns in my table then, is there any way to do?
thanx in advance

Report message to a moderator

Re: updating a record [message #21537 is a reply to message #21535] Sat, 10 August 2002 14:18 Go to previous message
TomazZ
Messages: 7
Registered: August 2002
Junior Member
If you don't have reference integrity constraints on this primary key, then you can delete row and insert empty one.

Report message to a moderator

Previous Topic: Triggers
Next Topic: oracle tables
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 13:52:23 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.