OraFAQ Forum: Training & Certification

Home » Other » Training & Certification » Stored Procedure (Oracle 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: Stored Procedure [message #314249 is a reply to message #314244]

Wed, 16 April 2008 02:55

Michel Cadot
Messages: 68641
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.

Regards
Michel

[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

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.

Report message to a moderator

Previous Topic:	views and corelated queries
Next Topic:	Steps for Database Refresh

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 19:26:22 CDT 2024