Double pipe symbol in oracle
I love learning about technology and sharing that with others
What is the double pipe symbol in oracle ?
Query
select * from Schema1.Employee where ACCOUNT_ID=('employee1' || '_acct');
select * from Schema1.Employee where ACCOUNT_ID=('employee1');
- both the above query returns the same thing since `||` this pipe symbol basically does the concatenation of the strings in oracle :)

