오라클 연산자 우선순위

SQL Operator Precedence

Operator	Operation
+, -(as unary operator), PRIOR, CONNECT_BY_ROOT,   COLLATE	Idetity, negation location in hierarchy
*, /	Multiplication, devision
+, -(as binary operators), ||	Addition, substraction, concatenation
SQL conditions are evaluated after SQL operators

 

sql>SELECT 1+2*3 FROM DUAL ;

   --> 7