Expressions di Oracle

Materi kali ini kita akan bahas menggabungkan/meng-combine value, operator dan function menjadi expression. SQL Expression ada banyak sekali contohnya salah satunya adalah simple expression seperti berikut:

select (2 + 2)                                   as add_exp,           -- value expression
       N'Dimas''s iPad Pro 2018'                 as str_exp,           -- string expression
       'value with enter' || chr(13) || 'value from before' as str_with_enter_exp -- string with escape character expression
from dual;

   ADD_EXP STR_EXP               STR_WITH_ENTER_EXP
---------- --------------------- ----------------------------------
4          Dimas's iPad Pro 2018 value with enter
value from befores

Selain itu juga expression di oracle, ada banyak sekali ya seperti

1. Single Expression
2. Compound Expression
3. Case Expression
4. Column Expression
5. Cursor Expression
6. Date & Time Expression
7. Function Expression
8. Interval Expression
9. JSON Object Access Expression
10. Model Expression
11. Placeholder Expression
12. Scalar Subquery Expression
13. dan lain-lain

Back to top ↑