| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
