Here I've found how to define a variable in Oracle SQL Developer.
But can we define the range of values somehow?
I need smth like this:
define my_range = '55 57 59 61 67 122';
delete from ITEMS where ITEM_ID in (&&my_range);
Here I've found how to define a variable in Oracle SQL Developer.
But can we define the range of values somehow?
I need smth like this:
define my_range = '55 57 59 61 67 122';
delete from ITEMS where ITEM_ID in (&&my_range);