Home » SQL & PL/SQL » SQL & PL/SQL » need a solution
need a solution [message #37289] Tue, 29 January 2002 14:01 Go to next message
Suresh
Messages: 189
Registered: December 1998
Senior Member
Hi,
how to check whether the information which iam going to insert in a table, already exist.
I know in sybase there is an EXIST and NOT EXIST methods,
is there a way i can do this in Oracle.
Thanks
Re: need a solution [message #37291 is a reply to message #37289] Tue, 29 January 2002 15:24 Go to previous message
Raj
Messages: 411
Registered: November 1998
Senior Member
if there is a primary key you can check
the value of column like this
if columnname = columnvalue you are going to enter
then
update(if you want)
else
insert statement
end if
Previous Topic: update and insert
Next Topic: Counts in SQL
Goto Forum:
  


Current Time: Thu Aug 13 07:21:16 CDT 2020