Recently met a problem, Oracle condition query select * from table name where id=0 and effective_date & lt; SYSDATE and expire_date & gt;=SYSDATE; To obtain all data, consisted of



A total of 4900 eligible data, click on the access to the last page, should be in 4900 to stop the query, but did not, in fact, it has been run, so I front page query when the timeout error, and after 4900 lines appear a lot of empty row, even the rowid is empty, suspend SQL is normal after all the data manually, the back of the empty row data is lost,

But I don't write a system can let the user query after manual stop, and change the id to the other is no problem, only at the time of 0

CodePudding user response:

Select count (*) from the name of the table where id=0 and effective_date & lt; SYSDATE and expire_date & gt;=SYSDATE;
Look at what is, may be PLSQL dev tools, is not necessarily the database problems, does not affect you write program query data?

CodePudding user response:

Just met the same problem, the reason is I kicked the cable out,,,

Should be your local problem, tuned the connection timeout time big dots, too

CodePudding user response:

refer to the second floor nayi_224 response:

just encountered the same problem, the reason is I kicked the cable out,,,

Should be your local problems, the connection timeout callback bigger

Won't, I this is the company's project, this is a test environment problems

CodePudding user response:

Use ORACLE multithreaded check,,,