Home » SQL & PL/SQL » SQL & PL/SQL » Comparing Values in Cursor
Comparing Values in Cursor [message #7314] Wed, 04 June 2003 03:45 Go to next message
Maumita Dhar
Messages: 1
Registered: June 2003
Junior Member
Suppose there are 2 cursors created with 2 values in the select statement namely coulmn name and a datatype of a particular table from two databases. Now i want to compare the column name and datatype of these 2 cursors. How to do?
Re: Comparing Values in Cursor [message #7321 is a reply to message #7314] Wed, 04 June 2003 11:51 Go to previous message
Barbara Boehmer
Messages: 9077
Registered: November 2002
Location: California, USA
Senior Member
You don't need cursors, just SQL select statements using the MINUS set operator. Please click on the link below for an example by Tom Kyte.

Previous Topic: Last Value from Query?
Next Topic: How can we return a ref cursor when using dynamic SQL ?
Goto Forum:
  


Current Time: Thu Mar 28 12:19:37 CDT 2024