Home » Other » Training & Certification » Stored Procedure (Oracle 9i)
Stored Procedure [message #314244] Wed, 16 April 2008 02:48 Go to next message
Messages: 1
Registered: April 2008
Junior Member

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
Re: Stored Procedure [message #314249 is a reply to message #314244] Wed, 16 April 2008 02:55 Go to previous messageGo to next message
Michel Cadot
Messages: 65090
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is NOT an expert question.

It is clearly stated in the forum description: "Newbies should not post to this forum!"
Expert notion is defined in the sticky: Not an EXPERT? Post in the NEWBIES forum, NOT here
Rules are described in: OraFAQ Forum Guide
Read them, follow them.

As you are an expert, I don't answer the question because you obviously already knows it.


[Updated on: Wed, 16 April 2008 02:56]

Report message to a moderator

Re: Stored Procedure [message #314270 is a reply to message #314244] Wed, 16 April 2008 04:48 Go to previous message
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.
Previous Topic: views and corelated queries
Next Topic: Steps for Database Refresh
Goto Forum:

Current Time: Fri Jul 28 14:38:02 CDT 2017

Total time taken to generate the page: 0.17527 seconds