What is the difference between {} and ${} in oracle

This article mainly introduces "what is the difference between {} and ${} in oracle". In daily operation, I believe many people have doubts about the difference between {} and ${} in oracle. The editor has consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the questions of "what is the difference between {} and ${} in oracle"! Next, please follow the editor to study!

Difference between {} and ${}

# {} when referencing, if the target is found to be a string, its value will be concatenated on the sql as a string, that is, the quotation marks will be automatically wrapped when concatenated.

${} when referencing, even if it is found that the target is a string, it will not be treated as a string, and splicing will not automatically wrap quotation marks in sql.

For example:

So usually, use # {}

Insert into user values (null,# {name}, 55);-- > insert into user values (null,'fff',55)

Insert into user values (null,$ {name}, 55);-- > insert into user values (null,fff,55); / / sql statement error

one

two

If you need to refer to a column name, use ${}

Select * from user order by # {cname};-- > select * from user order by 'age';//sql statement error

Select * from user order by ${cname};-- > select * from user order by age

At this point, the study on "what is the difference between {} and ${} in oracle" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!