Home » SQL & PL/SQL » SQL & PL/SQL » Could anyone please help me to solve this problem ?
Could anyone please help me to solve this problem ? [message #185908] Fri, 04 August 2006 03:54 Go to next message
nasdaq
Messages: 8
Registered: April 2006
Location: bangkok
Junior Member
Hi oracle expert,

Could anyone help me to solve this solution ?
I want to compare multiple records as shown below.

Data in tables.
ID VALUES
1 1
1 2
2 1
2 3

When I insert new group of value (array) are

ID VALUES
3 1
3 2

I want to check "this group of data is exists in database"

But another case

When I insert new group of value (array) are

ID VALUES
3 2
3 3

So for this case,They can be inserted because "this group of data is not exists in database"

I try to use "INTERSECT" to check it but it cannot.

How can I write sql to solve this problem . Please suggest me.
icon2.gif  Re: Could anyone please help me to solve this problem ? [message #186043 is a reply to message #185908] Sat, 05 August 2006 01:53 Go to previous message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
i suggest you to look in the pl/sql newbies forum.its already answered..and please show us the code which you used..
Previous Topic: Need help in query for finding search results
Next Topic: Date
Goto Forum:
  


Current Time: Wed Dec 07 14:19:24 CST 2016

Total time taken to generate the page: 0.14508 seconds