Parameters with null value

Hi!

I'm trying to use Datagrip with Oracle DB.

How execute queries in a database console with null parametr value? IDE shows "Parameters" popup window and doesn't execute query without filling all params.

Thanks.

0

Hi,

Do you expect from DataGrip to fill NULL if no value provided? As a workaround, you can fill NULL in parameter field.
Thank you.

0
Avatar
Permanently deleted user

It works.

Is it possible to add a parameter assignment to NULL without filling?

0
Unfortunately, there's no way to do it without assigning it in parameters.
0

Hi,

but when the user parameters screen is presented, it is not allowed to execute until all the values are filled in. However, the screen shows a value of NULL by default. Can't it be run without having to write "null" to each of them?

Only in the second case, it allows executing the query.

Thank you.

0
It's a template value shown by default. However, it's not being passed as an argument as a default value when running a parametrized query. Here are the relevant feature requests, so feel free to upvote:

https://youtrack.jetbrains.com/issue/DBE-7124

https://youtrack.jetbrains.com/issue/DBE-18962
1

Please allow execute the query without filling all parameters (default to null), because i have dozens of parameters in my query

0
Hi,

We have a similar feature request created on our tracker:

https://youtrack.jetbrains.com/issue/DBE-7124/User-Parameters-Allow-empty-missing-parameters

Please follow the issue to stay updated on the progress
0

请先登录再写评论。