Monthly Archives: May 2018

Define the order of priority when executing sql statements ?

  Order Evaluated Operator 1 Arithmetic operators (*, /, +, -) 2 Concatenation operators (||) 3 Comparison conditions 4 Is[NOT] NULL, LIKE, [NOT] IN 5 [NOT] BETWEEN 6 NOT Logical condition 7 AND logical condition 8 OR logical condition Advertisements

Posted in oracle, sql | Tagged , , | Leave a comment

What is ROW_NUMBER() function in oracle ?

Before knowing the ROW_NUMBER() function we need to understand the oracle analytical functions: Analytical means to get more control & allowing to operate within a table’s column or data like: Analytical functions also know as windowing functions. it mostly used … Continue reading

Posted in oracle, sql | Tagged , | Leave a comment