Useful shortcuts for vi editor

Wednesday, 5 November 2014

[CONCAT] How to merge two strings as a single string?

Please run the sql lines in SQL Editor as "hr" user;

e.g.
select CONCAT('Bilgi havuzu ','at ozsoyler.blogspot.com') from dual;
result
Bilgi havuzu at ozsoyler.blogspot.com

Used database user: hr
Used database server: oracle xe