Oracle SQL Developer
-
Hi, I am having an issue with the selection list, which does not allow a selection of more than 1000 rows. Like if I am trying to select more than 1000 rows, maybe the customer numbers, it does not allow more than 1000 rows. It comes back with this error message, SQL Error: ORA-01795: maximum number of expressions in a list is 1000 . I tried increasing the SQL array fetch size, and also increase the fetch size on the property window of SQL Developer but with no luck. any help is much appreciate. I need to update 4 million rows. Thanks!!!
-
Hi, I am having an issue with the selection list, which does not allow a selection of more than 1000 rows. Like if I am trying to select more than 1000 rows, maybe the customer numbers, it does not allow more than 1000 rows. It comes back with this error message, SQL Error: ORA-01795: maximum number of expressions in a list is 1000 . I tried increasing the SQL array fetch size, and also increase the fetch size on the property window of SQL Developer but with no luck. any help is much appreciate. I need to update 4 million rows. Thanks!!!
I don't think it is related to the row count. Google the error message and you will find numerous descriptions and workarounds.
-
Hi, I am having an issue with the selection list, which does not allow a selection of more than 1000 rows. Like if I am trying to select more than 1000 rows, maybe the customer numbers, it does not allow more than 1000 rows. It comes back with this error message, SQL Error: ORA-01795: maximum number of expressions in a list is 1000 . I tried increasing the SQL array fetch size, and also increase the fetch size on the property window of SQL Developer but with no luck. any help is much appreciate. I need to update 4 million rows. Thanks!!!
I bet you are building your query like this ...
select xx from myTable where ID in (val1,val2,val3)
The problem is that Oracle has a limit of 1000 values in their "in" clause. For example you can not have val1,val2,...val1001, Oracle will throw an error. You need to restructure your "where" clause. A possible solution would be to create a temp table and insert those selected values into the table, then do a join to the temp table. Somthing just doesn't sound right if you are selecting 4 million rows, but you haven't give much information on the problem. Maybe more info will lead to a better solution. Good luck. :thumbsup:
-
I bet you are building your query like this ...
select xx from myTable where ID in (val1,val2,val3)
The problem is that Oracle has a limit of 1000 values in their "in" clause. For example you can not have val1,val2,...val1001, Oracle will throw an error. You need to restructure your "where" clause. A possible solution would be to create a temp table and insert those selected values into the table, then do a join to the temp table. Somthing just doesn't sound right if you are selecting 4 million rows, but you haven't give much information on the problem. Maybe more info will lead to a better solution. Good luck. :thumbsup:
-
Not selecting but updating a value on 4 million rows. Anyways, it is a limitation on the sql "in" clause select. You cannot have more than 1000 lines in a sql select. I will store the data in temp table and join to it.
My bad for not seeing that you are updating, not selecting. Oops. Good to know that you have a solution.