Browse: Home » Oracle SQL

Oracle SQL

  • Oracle Power Function

    November 7, 2011 Respond

    There are some pl/sql functions that you rarely use and we always forget the syntax.And here’s another example — the power function. You know, that’s the n to the power of x (n^x). Again, I feel a bit ashamed for forgetting this one. Here’s the syntax.

  • Select Random Records in Oracle

    February 22, 2009 4

    Recently, I needed to sort the result of a query in random and show a limited number of records. Honestly, I didn’t know how to do it and had to search various online forums to get the correct answer. So for my own sanity, I’ll be posting the solution here. Step 1 SELECT field_name1, field_name2…