need a solution [message #37289] |
Tue, 29 January 2002 14:01 |
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 |
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
|
|
|