Duplicate Sql

5 pts.
Tags:
Oracle development
Oracle PL/SQL
SQL
Hi, I want to know in a given PL/SQL Procedure or PL/SQL Function How to find the duplicate(i.e., Repeated) SQL Statements. regards, aditya.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Aditya,

I really don’t believe that there is an easy way to determine that. I have attempted a similar process in the past. The issue that I had was dynamic SQL statements being built, along with embedded SQL statements. The only shorthand method that I was able to use to find duplication of SQL statements within PL/SQL was to do a string search on the various from clauses. To find possible identical statements and then manually compare them from there. Hope this helps.

Regards,

Rdano

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following