Stored Procedure [message #314244] |
Wed, 16 April 2008 02:48  |
kumar.oracle
Messages: 1 Registered: April 2008
|
Junior Member |
|
|
Hi,
I need a help in writing this procedure, the requirement is, when I give the "Table Name" the procedure output should have the following
1) check the primary keys for the table
2) do the duplicate record check based on the primary keys
3) If duplicates found return back the record count containing data.
Thanks & Regards
Kumar
|
|
|
|
Re: Stored Procedure [message #314270 is a reply to message #314244] |
Wed, 16 April 2008 04:48  |
JRowbottom
Messages: 5933 Registered: June 2006 Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
I think you may be misunderstanding what a primary key is.
If you have a primary key constraint on a set of columns, then there will be no duplicate values of those columns.
If this isn't what you meant, then please post an example explaining what you did mean.
|
|
|