Oracle SQL Syntax meaning

Question

I am debugging someone's Oracle/Java program that I inherited. I know Oracle fairly well (SQL) but I ran into this sequence which confuses me. I made generic table names but the rest is right:

 select min(latitude), min(longitude) from mytable.myrecord where zip like ? || '%'

Now this is a prepared statement so they set the "?" to "10003" to search for that zipcode in NY. What I don't understand is the "OR" part (||). Doesn't that mean zip is like 10003 or zip is like '%', which would match anything?

Evaluates to zip like '10003%', i.e. any zip code starting with 10003. — jarlh
– jarlh, Commented Dec 2, 2021 at 13:09
|| does not mean OR. It's the standard symbol for string concatentation. — The Impaler
– The Impaler, Commented Dec 2, 2021 at 13:13
Oh that makes sense. I am used to Java and C programming, where it means OR ;-) — Tony
– Tony, Commented Dec 2, 2021 at 13:29

Sergey · Accepted Answer · 2021-12-02 13:06:17Z

2

it is not OR.It is string concatenation https://docs.oracle.com/cd/B19306_01/server.102/b14200/operators003.htm

answered Dec 2, 2021 at 13:06

Sergey

5,2801 gold badge9 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Oracle SQL Syntax meaning

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related