How can I optimize this dynamic SQL query in oracle with PL/SQL?

I want to be strong in Oracle SQL & PL\SQL and also improve my problem solving skills for more efficient coding. Assuming that I'm an amateur, are there any good online resources where I can solve problems and implement algorithms using Oracle?

  • I am aware of SPOJ and CodeChef but I'm not sure which one is good for me.

  • Answer:

    You mention Oracle, so are you aware of the fact that you can download a free version of of Oracle database software. I think that the current available download is Oracle Expess 12c. Oracle also has a learning library with demos, tutorials and problems along with step by step solutions.

John Rainey at Quora Visit the source

Was this solution helpful to you?

Other answers

Enroll in the online course - “Oracle SQL & PL/SQL Training (over 5 Weekends) - Starting August 2nd” @WizIQ  http://www.wiziq.com/course/71560-oracle-sql-pl-sql-training-over-5-weekends-starting-august-2nd

Thedata Mart

Register yourself at http://www.hackerrank.com and start solving the challenges there.

Nimesh Mathur

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.