Oracle Database Certified Associate (OCA) less than 1 minute read

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