2 Replies Latest reply: Oct 1, 2013 12:26 AM by Ramin Hashimzadeh RSS

    SQL Learning

    user12050217

      Hello,

       

      Oracle Version 11.2.0.1

       

      I want to learn SQL and specifically row_number...over(partition by clause) and regexp function, because these clauses and functions are very much used into solve the sql questions.  Kindly share your code in action with explanation and/or a good link, book to give me a start please.  I tried to understand from docs, but simple example with explanation will help me to strengthen basics.  Till now I have completed where, group by, having, order by clauses.

       

      Thank you.