String concatenation in oracle

String concatenation is joining one or more string to build a new string. Oracle use [cci]||[/cci] to join two string. [sourcecode lang=”sql”] SELECT ‘semur’ || ‘jengkol’ FROM dual [/sourcecode] Above statement will result string [cci]semurjengkol[/cci]. Note, you must use single quote [cci]'[/cci] to represent a string in oracle or error Read more…