What is the Parameters section of Database Console for?

The database console has a Parameters section on the right side. For the life of me I can't figure out what it is for. I have never seen anything in this area besides what is in the screenshot. I don't seem to be able to add anything to this section either. What does it do?

Screen Shot 2012-02-17 at 3.04.22 PM.PNG

2 comments
Comment actions Permalink

When your SQL query uses JDBC parameters (question marks), it allows you to specify the values for them.

0
Comment actions Permalink

Ahh, that makes sense. I thought it might have something to do with bind variables but couldn't test it from my code because none of the "execute in database console" intentions work for me (probably  due to http://youtrack.jetbrains.com/issue/IDEA-70265?projectKey=IDEA). So I just use the database console just like I would use DbVisualizer.

0

Please sign in to leave a comment.