Hi Thanks all but still i couldn't figure out any thing.First i'll tell you my problem.
I am having a table say xx with three fields say x is primary key, i want to isert 2 or more row into the table ,if that rows are found( value for primary key is not in the table) i have to insert these rows, else i need to update these rows.
I thought of writting a procedure which'll update if select statement throws exception else insert the rows. But then i have to call this procedure as many times as the number of rows.
Is there any way i can reduce the database access.
Im new to oracle . can any one help? Regards, Anuja K
As mentioned you can do a SELECT to see if your row exists first but you can also see if your database supports REPLACE syntax. A REPLACE query inserts values if the row does not exist or updates values if the row does exist.
Hi, I am using Oracle DataBase ,I don't know a way to replcae a row in oracle. Is there any way to do this, Or can we write a trigger on the table before update if the row doesn't exist to perform insert in to the table? Which will be a better approach, trigger or a stored procedure ?