Skip to main content

Command Palette

Search for a command to run...

Double pipe symbol in oracle

Published
1 min read
S

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 :)

More from this blog

H

hashcodehub

271 posts

Consistent, Passionate and Organized :)