Home » SQL & PL/SQL » SQL & PL/SQL » What I thought was a simple insert statement!!!
What I thought was a simple insert statement!!! [message #2672] Tue, 06 August 2002 00:45 Go to next message
fred Geeves
Messages: 14
Registered: March 2002
Junior Member
I have having problems inserting a value into a table but it must meet a specfic critera. So here's my statement

INSERT INTO SIMS_ITEMS (ITEM_NO)
VALUES ('655')
WHERE GROUP_NO ='24'
AND CATEGORY ='T'
AND SIMS_REF_NO LIKE'02%'

Report message to a moderator

Re: What I thought was a simple insert statement!!! [message #2675 is a reply to message #2672] Tue, 06 August 2002 05:51 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
u must use update!!
update SIMS_ITEMS set ITEM_NO='655'
WHERE GROUP_NO ='24'
AND CATEGORY ='T'
AND SIMS_REF_NO LIKE'02%' ;

Report message to a moderator

Previous Topic: Bizarre behaviour of a Function
Next Topic: schema for all tables in a database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 10:01:18 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.