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
Messages: 189
Registered: December 1998
Senior Member
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.
Re: need a solution [message #37291 is a reply to message #37289] Tue, 29 January 2002 15:24 Go to previous message
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
update(if you want)
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