Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Does SQL Developer allow to change data type of a bind variable?

SirajGulamMar 6 2019 — edited Mar 6 2019

Hi

I need to run a query which has bind variable that are suppose to take date value. When I try to run using SQL Developer, it does take value but treats as a number and hence query does not get executed. I am certainly aware that Toad handles this well as we can change data type. Do we know if there is anywhere in SQL Developer to feed bind variable data types?

pastedImage_0.png

REgards

Siraj

Comments
Post Details
Added on Mar 6 2019
9 comments
2,327 views