Double pipe symbol in oracle
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 :)