https://forums.oracle.com/forums/thread.jspa?threadID=447344
@H_403_5@相关部分内容如下:
@H_403_5@There’s no setting to fetch all records. You wouldn’t like sql@H_403_5@工具栏上还有一个“全部获取”按钮。 @H_403_5@FWIW请仔细检索所有记录,对于非常大的记录集,可能会导致您有各种内存问题。 @H_403_5@据我所知,sql Developer在后台使用JDBC来获取记录,并且JDBC setMaxRows()过程设置了限制,如果你可以改变这个(可能不受支持),那么你可以改变sql Developer行为。
Developer to fetch for minutes on big tables anyway. If,for 1
specific table,you want to fetch all records,you can do Control-End
in the results pane to go to the last record. You could time the
fetching time yourself,but that will vary on the network speed and
congestion,the program (sql*Plus will be quicker than sql Dev because
it’s more simple),etc.