温馨提示×

温馨提示×

您好,登录后才能下订单哦!

密码登录×
登录注册×
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》

【Case】result set exceeds the maximum size(100M)

发布时间:2020-08-07 23:22:11 来源:ITPUB博客 阅读:186 作者:TaihangMeng 栏目:关系型数据库

一、问题现象

    在PL/SQL Developer上执行一个select语句,然后跳出来一个警告框,信息为:

    result set exceeds the maximum size(100M)if necessary,you can explicitly confinue this query


【Case】result set exceeds the maximum size(100M)dnSURBVHhe7Z09zOs8lt/PvRlgXCww6sZFgLiLS3VxF08Vl94q3irezlvFpVNF6Vy6i7t1qrgIsE7nblykUIAU7uLtvJ0HSOEX2MIDDHBzDilKJEVKlD/13Pf8nstrieI3Kf5FipK+nU6nH/v9HrrdHtxuV7hcLnDFv+1mh/vgpdPJNpzQwbLnqvBCccdbmRiGYX41uDoZX//weB9V3Q++B5Xm8LTYDs1M39tPh/XNdwaODIcD6Pa60O10IYoijC+Cb2maZgLWhev1CuvNRjhezOcwmUxwq0ENVTmtSneDKJgWcH8bfDtfKKklvtxp0YYE+yrclbZXNQ47rnvjcaT5d7/9LfzhD3+AP/7xj5nNz4vK5y+//Bm22w0sVythPx6PoBuhkKFmfTscDj/26R4i/FutN5As5jAcT1DMbljuVSXvbq11bViFWOfOiyXzd4fzIV51zjyCSFNAwpST/IrP8mQH4bqSe/UV671Xj63BUz6dL9LSH63f9+XSarvGrtoxU3P/CIe4p2HKcNR5dsOtfrcDE+zAl8sldG4niC7vK7F3ce2i8nT6sFgsYLvbwxm1iHLZjTqwQyFLliscXEkR+365XOFyvuDIa5uL1wVHYqZ4kXfbmLhtyzjdUcsINRrmXnugkvOZthGaJt0dnVBV4nXD3oCMtDUNWevGh+0u1Hx5KA8Oo8q06q/k6SFzH4/WgZ2KB4NzEBIq9Syyd/F0PRX4HJJ9cCBI4VZ2326os/eZtuNKqy/dZEtCRvpEOrVDYbtcL/CdDtHUISHFSwWgCrxJoTdABI3/OUQp1LQNKjl38b8flZY6U4XpLtvSeih2rLChw/qeC90XdruqY8Zd3UikG9PU4fLjMl+Uiqy4DjU1Ba6jYaaoU2lEhSrjcC+NH5drtyn+zD35J+0khR9p8g5F71ju6mRUDC6qjtmYbm0RE2V7Mo1NW0XMFi2CBk1i4KTyI9pKGZKn8WQqts/nM3ybL+Y/SM3onlc8Gss2FsDdAuL0+OQJkqrA3linr4zqqWE7AjOtsj3LXdkbNbxss8XoSaSm0tYkP/WseCCop56bGka4r4qkCaohUFpo20pTG5LY70ZiCjFJEuicTpltPT2Qg5RPc4Yo26rm1u+LPKopRB2qh4S/FffEvi2Xyx+0cCNNj3C6UCb9p/PdJ1SFN/PQA03kAa9PRytCf2k241nh6FQEKA95HKB1+Uhh82kB+3D0L+HpTdsZYLNYXnW6hU/VOfBVvh0muSM75V7fbooV9j3JV8kJQQnYZjYTI5am1AnZ5niG9HrJ9iSDqAvTuJfthbmxCRUuRTeKYLpeawKWVVBWWD08PhjE8C1ZJT826y0cUcCOFzNRNs0rR/NheQ4Pq8al43B42AX3tt9aMODQsF+WhhCMdFanxBQpy1e117t5UbA/HQ8JgOCxAO7yXeEpODxsILKN2C0l9LL7iS1MqwS6V3y7qf2AONBvVXrFIo64D6vNEq7pObN9HqvjEf7hv/9Dtif567/5ayFQg14X0vNFiJfLzTyOs73HiQY9mCcbIWByYGUS9yKIMb7v+VxjTS2HNQIbCjsLX21qVmHYHnVTQOlT5h60//cYL3hQtOeaCxAzN+8hL0n8LzR+4c6R4VD/VYi0eAwTANaLq+yUCaOZaxs9vtpQqB052pKOL7zcDv8T94NKLhTymHIhMOIs/KktMnTRX2fwn2FyZKKEoR+HCz/Cg0yr7SMwhJzu7RpkdEioSIx0SKxItKrEi/y5wnMR6g7ONEXqKgU09A/Nd2lZjx1MM7JINSManWWaI/3UnANvoe5c7FBSScQ8QvbOPKhayCkl3p2akh+B5dbt1fRrUUoPY0JlGmJqaFbOz6mVUigN0uuinCprD3d1Y4L9jOFebtP/ytbtz40eDxmfsOmiV2Xwn4DCKpbOS+hXjObkLno4w82axrO5dCJh7lCCQmaMI7wqEfOJF/lT6OG5DBGSrgLKtTSqrBXBAkZ0sshfxT1C5j0PIjzyDpOfjdKoLRdCxIgPilhl6RqJN3Pi9NcwwSoM/bcyPUzjMg6hWbk/p5aeE4qF1lfoHZu9bSP7GCkG+mHbfxOjU3WsCuFe21aPq5CdnIpsFt69VImYjku8XoHKtyvv328k/QFEmXi9WsQIJWRBYuZwQ1N2JBavNuKySY2qhCiRpcRXpcIfkft5DxRtkboaHImvbqLWvL3lWI9XbQelhcJRpooQN3XocenGhcvdq8wLadQmctfhPt6FniK9O1Db9Gt3E9auqxsJogfyPpSKQw9Ht6szCrGvb6NR4qVzuvXFL43C6sw96CL2yy+/lMwj4nXGzFSlUezjCDOEfBn98XiE07kIyCqvXMB0bo2Ggc+lk90oFf9rN02JYrd54d5Dfo/WcTFQttHcK7Sidbl/Jo3CF44LH16/eACbZLaDuDe/BlQ3IYl+T9N6Ofdn4z6f1qn6GFmvrnfudkdPqDir4lb+bP/dm3up+qUjBUShhIw44x6h39VBfvT05WmWPwJKGq1CnA36kNAqxPQgDyAdFJM6up3mg489ZuEYdWC9Wmc2ALP5DGLs60b+RYeVXG71utEdDGGxTGCdnuCsLeJQXeyoH0E/HvgFjNDr8rzswVS+JhFgsILdeoxFfq0Vsdt5CcORzHy8OsD63lxb1AuYaVdL5wKHGeUxgd1tAbHVkH2UxIgQ5S0D8AVj+HuDgN0VruHJkKgS8sTXXLg3fx4aNq+2c/cjMndinbL3gY1Ob3ZKfK7ZauqoKzv1PC789UXrEjAlXqer2cf1o+KEtYWMcIkZUSdoVSJGyaK00eq7KYpYskABOxQCVkXvgcI+dLpeARveTL0IhUZgdfTGE1gsEtigeCkB08cHSsC898DILWVbjbx6izNs6AFoTbzquGGVbEi8pjtIT2eneEWq9b2byx4mWDEb9QT7rQvDFab4Gi5eRD4lqEo3L5bARqMV4ytKgsJsHO4dnny5fUWemOdDUlB9ifJcAvqw5+OJ0ydeJFxKvLpQdNaGvWeE5kIXMwXZKXva0tNA22Soa1H29/SXJBjKNEGJ12q5wvixdWSG9smejn8ar4Ap1b9WjLBCpxDj2O/uWtPRf0zgGhMoWG+CSu2ukvN4+iq18DbuLuB2o4SM/l5Nw/7UT82pd080+qhLiZcuYjq2iClBcgmWD93t08rlAXTxctEWEascgVVBSpxOezBYHuRvPzPLozjeOW1g2B8CzToe50M8toBTVv+3/bhwTwZHaBQfiRX5m6PddrMSx/r9LQ4hU1jj9gKHzPRL9nGvC7tLB4fRMzEvLM0KrzJkHMRx3oEeFnJuVqmwP+8m0OuPgfaSQYTHphhW5n6+x2ZaBOILQ3BZCr+H3UY8YNjHoXq/O4W9Nqr6hKzd1f7JU5VH51xpgfTaLhF/C3cV9tfgHUJGnXUbOmwd730vlDAdJXKuaURCjq1MY2PbqX1XmbyrnJR4LZOl6OeVmS/mxj4d/7SIOQWsrpwwzXQ5ItlMYTNBETud4bCf4f4YVlT/8QzScwo060j3vtLTEjt3FI9lD4bzPmwOZ+nndIBpOochCp8YjUXySmS1jGB7PMPpNBHffSEOsyncdmdxv241kOIzPEzgcL7C8bCBASQw2kgBjeAI6WYJOyxoehXJ+ZSgBxTU0w16YxTF0w7do1V6xeMbGNt1QPfEULzG4p6YCgP9YBiLg34ltoXZ5CLcnK4nLI4tzJcogrj/bijGxrE28VQjYr9a7ir4rwOJGP29EjpdHj5lApqnHYWKU49bH30pbPEi9HthNkqyQvCJ27O7kJB7Ybp46SyShbjvRb867xQxoTsWJQHzlZlrFaJguoFVdm+r058KwdrupIjo0KKLzuUAKxySxSsaNWX2WHVTIXzbfIRGxKshFrg1xYgjNdQ+TEwXhgsUJCSZjYBWcnZwRLWgyM8XMdC/Qgyz6zy/nxV1RyJtrteSODlvKGsocEUYgGEsUaC34w0ctWSRG3EN1ulBbzgWeTlWdPav0IG72nqAp1LH4kl86dx4QR6Zz9I+ITMbmdqjxRtqAcczcImXwjf6UhRjr7Jxodvb55S+71t12MF824aEK3QhR5V40aKNKhELxZVGH3XBGgJ2X9OMMBIUp8zENKzxccVRF0xgbr30MeoMcDS0Nabe+r1yBdO9NLX6UDLBivELEo3CEiwBmvqLooGYzgzlnJIIJxinWYK9Ab3v6wTn/IJpgmEXbqLIfB/Ya093GX7jOAI8eTuSfNWKidut+Mf8ZLRFyIw0qIZmNzi9DVrH7s0BjbxIIH3iRV2UbnzYQlYlXi5CheASRcFGCZRu9BWHuojZblzhuYyLkHwQtqB574F56csEdK4VJdxDock2iU7FFUwVShTv4rIUokVTjjT9d73K6cx3ETVcYnrPydTYD3kI8FTqONST2x7x8iE6oWz7V8GvKrOU3eJPZv75BVAlYrVL/+u6jsDkqhGdMlWjLld3RXYuo9CFzD5G6HZ1i95oZOYzvS5ezFcYchN3I5hiZLohu2uvnxufm5B4lBvb6LjsdKSIyXKoFTByRqa04tAKX7irEjUi6omR1upYzPcKgcpGZiNPmpWIKSGsiUVwXCZyynEo003PhoQveFUjrQSOR7OVy5FZH0oDRBRJG9f5YczAZYPHwPMoh9w39VPlQV3tKpNzh3jptRNSTz8dTYvrJ4GyLc3zC8Bun6qNZj8Gos3Rf1nje6QNKsEKJeumgiH3ttHJ7Wk72yc6vS6cuz1DAPROv0Niohl6gFk9xHzFPthndLf3GgrDFbYyerqUIYx8oN0ZR2qUzzoMAcsLSjM69r7CaW/XBtEbwRyHQcf5Gk5YniRMN7z2WI1JbCao4oUfWlXowpcGmyi7F5VepI/jUq46tPHeE+tNxXNvyWBV3O+67GGBojjZTcV9sautiP7ZzDJN3Gq4TtpKyIPHk94ZGNwlXA5CK+tng4ruE6YlvELEbNzt1vgxm19NW9S7q1DhEuKiGZddlXFhuKF93U64wPQNBuJrxPS2ClsMyNjoAlKH7vYecw92+qNeDKfTCYZ9eTtGLxMb600c1Ku6Gx+tHpyom0jTDaRJH9LJAOajA5ym2ZD6doU9bgu7WYyDkhOsewM4rfB3XBTsKekWYREoCsdkICrodt7DbDiFUXqFSfbZ6SuKnApnM5EN65auIB7j/nEJg6zSTosIxjjCS1cjHCOdYK7f90oSmKKhKcVlNio7ztG9cDCB1WkDvWUn9y9iwSsK+XYO2pFM0D+tfiRcadDtaFitk4++NPEKPdUr3TU8GBpnMBhgEaYZurOjYdqBo0N4Ns2juCdRViPTdx3BKSvhzNE+9Tbr6jR9+NySNQWpfqvQg6Dw6HW+CvFyX2F5g8VoAMPpDAYoZt2O+3ZFlF28t51r1s8Tl1sX0jSFw2YNy30q8mtObskdeoyqjwLnEDBCFXcGbrqKwrDz1Z7WGox0aHh8SnzhthxXXu3O3FceOoabEA85bseNggikLFKZBf68Ij7mTTzx1GseVKgPamHktllLM3w08BrSHUkntsPHItHTS9s0WbWdTeF0OcHFcfsilK61KkIPSx1rEj75eTQ98WAE42SJwoVjeU9Q6oOWHgHTwDyYWSzI7etq1UqFvlfy+VTBemZYirDKcblqJGDawbAYFdWum4VVgzeNuOc9xvxaePxUbhJAWCujEMml+hVUeG2Sh4xRSagfIwHoyfJXFQyli1ZXN6POfUVBNKJpusrQc7T0sLTC7judAnZEAStFjRbVyaGVgtlmFZSgbFOHvIrqa71w+TBzVcpjZuHKu8+ti4pDjRGN4Rn3uAgtGCNEu8UhjWJs4vid1c0EYVaJo4LeWGcqKuqBnhdtEZIR5pMiaBIMnSrPy9czoVRh7lTfTn2Cti3WQGT9RHj/j+7xX18J2HQ2/XE4pP4RGJGFHRrFcyjH1kzj3plaz23rzNJ5DCnZ+xxm1BxuhENfHqAILN8SG/WReF3Uey3z3gb6q6F2ufojvLjO3MFT46IjTRqZy72nZELzpCdD8xPqvd3IXIhvmeH/6ldSZFz+n7kO7eCx88oFLEmSH5vt1j8C89BMTB7FH5k7HW9NXI4hY9mmZmNQsvc51Ahw8hCPi1oRgBFUbbieCwDGy0tF5RU8Kbl6MNRmaD9vO6VGJ12H9VXYBj2NsN7/E2sDAzLD0vc8CWwlMt0kXIpCrtzkOfUVuFZBZQFLUcC0JeWeID5CE5GSbj+Ten3OVlHV5ErHqhx7uMPL0/ALXnEg36INvVoCE36PtH25zv1n4QnF7g/CPmK2C7Mt6jumP1dfIv02b2cKFebT2h0GU4Skh2lOo/8cLOPTBRnH/fn3I0deOnWxeJOoQWHk98B8AiZ5RaaaUdsosFZsF8+9nxZGU/Eiqo7fXvHCxKdj5sB9MumWep6kfZMTkHkDL2p2r7mocLWhYiRVdANm3Mq+8Gc2Ql+bDO1W9PBpW/2SNS3Q09deqAV7hZ3cKOLSHGvp9KW9Hjt8gnbc4bj6NRcyPCPQDFPEQlPrCkn3S48oxQOvgJnRqDzomQ7Jl1lIZerCqPMvCycDHevO3yVidgUHFEuJu/y0UuBkTgLbvIEYad1TEF+JNlaZxWuE5pUowfK3PdkVFPlSXUPh2u+3Cc/ocui9sopikzb0ND6YUAHWtBE+oYfrn1Ktw+57XaFLbBvTn58bClgX+u4RWBFoSAbsK4omdK7lTwjo3Gqe7Jbl9H4Re4Zo6Tzsv0ViFnrF5uNLC9kHquHrCc5zKdpbdYer9wVqU7qXnh6stk9BpcstYmZ6Fa5HrlwjPKLcT+siVuA6h23x6NhhG+Wd/ZpBlOur8GInyvKJuwN6kLksYMUT3XrgpGv0uslXogotRHToxZfkjApNOpd+5Ka2Tb8B4YXgqtSyzf3cG1YbR2KPipjirWL25mL8tQvPs5BtzewM6b2nhP06KHdfID3aTVaFUUWT9ySGovo1vUGSXZG+Wy4mrtPMlUVyp+xNoSkLmH3uUlxkVdX/6y8i1sMvyptauzibNfwXHNIb/Vc4sN1WCpjumMRrQB/mejHlm32BcRo10CldCbQBTz19FF/jaTf3JLqFDYJ5IkWbUJ2v3rZVZ2h0Ez7QI3mV/rVAKpEB6+HbUVFIIdELQhL6yMkbVBAZ98bjjIPs3OHRl/h969/PpXUZkmABo6e9D/sd7A/7zOY1XB0Jjax3CfroRNUflWMY5tfBrfSG7fD+weX30+hpf0X67LJ5ZhxV5R4Sz2g4guF44hQxS8B2KGCpV8AWixls1vrbdxmGYRjmdUxnU1iuNpUCVvk9sLobdwzDMAzzKSoF7JGpVoZhGIZ5JSUBM6YPX7zykGEYhmHupXIExjAMwzCfQC0CqVo4yQLGMAzDfEkqBUw9oMYwDMMwn8I3CisJmO4w8DEshmEYhnkRUpRIm5RRWAKmHclo45stGIZhmF8TJES6wf/xxzGFKF+7olQu/BOXDMMwDPM+PPfACoUTv4GvYmEYhmGYZ0EvBCYZso38LxewW25RkDtlGIZhmLdjKFA+oipsPSMwhmEYhmkJJFr0lg1NvIjv5wu/bYNhGIZpH+LFUPnIi/4jm+J1Ud+jiNfKMwzDMG1ECRYabVPhmUJ0uGQYhmGYd2NJka5KhoCZs4sMwzAM8znUy+WVhmXfzCYrcaw0AqNP+9tC1sYvlTIMwzA/P4VoSeESZJu8CpFhGIZpHSEDJ6+AqVFYpKsewzAMw7QEU8CEahUTiLT17ldJXS4XSNMUdrsdrNdrWK6XMF/MhaFtsqNj5IbcMgzDMD8vpEA+FSot4rCeE3sbp9NJCNNmtxHC1Ov1YDwew3w6h7//r38vDG2THR0jN+SW/JBfhmEY5udCnwF0CZlzCpHeP/UuSIj2+z0cDgfodrtCpAaDAdxuNzgeT2ifwn/5b/9TmM1mi4K1Rz9XiONYuCU/5JfC4BEZwzDMz42uTrWLOF55D4xGTiQ89DD1dDoVv8fjEdJLB/anPv7G+NuD81ma020ozDaNYLVJhaARyi+FxaMxhmGYnwTfYCqzzgXsd7/9rRh6Kedi+4UjMRIqGjkNh0MxJUj7p1tXCNfhcIXrVZrLLSqZW6cHV5ACt953hJBRGBQWhUlhMQzDMF8fpUUuPSqPwMgh/cg9sf9saJREizAmk4mYKlQjLiVchBIrYhRfYDIC6Hbw+AVN9waXKx4ng3a7aw+W64PwS2FS2O8Yie3nkRj5GWa+z46+Fop7uOLR5j2cVsMn1dMJVsMI3lTlL0G24Tl81Sy8I/0iDqOS9zCnc324whZQxugXHG7qjutIt0Pwn+pZWrT0ifatws+M3lc8r/2/B12PbCGrnEJ8vnQVqwxHo5HYplGXEi59lKWYT7vwH//9v4H/8G//FawWfej30PKoTWte0ALNqdOF9XYP5/NZhP22VYrTbT5avF63MN1MPiMs+3ntyXA3rwz7K/ETlsNoRe12BXh9+CV5efqxzieA5/iKYpAXLFG0hF7ijpHEYXJMIBX9QQoJ/g0scak67uYIu7271Z1WSzj042xPQ++X0gQgGeQXWv35AdLe8stdACsh03WpJGDinhcp3AtGXgRN7/X7faGi6RmEeNmipfPv/vVvsy05zTnEBuQERewcDYSIUdgUx/unEkcwS2I47vbc2TPMlwcFa3mEZKbEqg9zcbF9gHm/m9np7GGdHGG6mKNLAt2vE4g3+2yEWHfcTQ8F6pisHW5OsN8F9HH9OSymAJt9EUJ/voDYGWa7IBWKhGplmpTpEmkBURIweu6LREwYcp/ZPwOa1qMREq0gpBHS+dL1ChdBU4X/+Kc/Z3sSW5NuvZsw0JWfhSER26KIURwU10cWdcQ4Usw2CXNIb00H0FV96RhNC1juTisYeqZKxDTDZIOFg1dzFI7vis4Zl8SXxuCwEV8Y0l5Pe3Yla12ZFn7NabnK8kPqjttTNiUqykVRVQ7Xq7oyd/uvS58OxTNaHrTwsrIQ9a/srHZgHEOjjRLryp7i06/Em8df31bvypONp46M9BtuNKPVVZO6gP0akniBYpXt14F9DcoTjPTBGV5Ix7ABoR11xz10xzhOix1uKH34t51k+zXEPZq+UtDF9hGWlQXwWToRFXwnfxZZ1yWFIWCZuAkPyjwTEhMSFvo9XodwqpjhI/GiqcLl+gT/+x//BP/0T/8kltKnl0LBhHAhnZsM6IaHyGywTmj0peJ6G3hCTpKrdsUmT5jBbpxNGaDZxjiaz05WdB9PDpCkxbF7ENMoW7zEirOpCTHdYVERV1Uag8JGqsLoz6kj2OQny2k1EydemoUl/OLIdav80pRHRmX5BRynDq6YskGzOGNc2lVQYB1UlcNuNgNYS//bKV2xmwJSlT4X6RLzn4WXYrlsJtjZiijILhVlOdE65XR3gbFKvzUtVVf2LprGH8JDYYaeJ6OVPJ4ZikfUl97OGtTF6YR9iNHp14AXzMe4B6YP3FfJrTvu4dbpwmiMZbY0p6/3+w3EY3895qCwTzZTWFhK3KeRHaap1WgS5NIlU8DQkLoJk6mdEcIDiPtdFylgaXoUDahzO8tFGQ6j7nOdsHxn2zOMZ0fY0ap5uudloYRLEV17sNkdpIBhnC+9F7aZFFd0eEJur0ftio2mDACStZoyQEbYgeDJqq6m8PqRLsIkeAIGX+3dgTuu+jTWUxeGnCpBB+jSdptNq2y1+xj9Ocg+py7c+uP7DXZSxvEViky2nfFoHdBUjPIzmiUQH88gu4W69HmYFlf9NNVDyTWmnWg+6HjKO7PBYqml2T5eVfYeGsYfxINhNq4jdTGZ57V5XZzPKGB5pI9xrLmQrjsuyuy4g/xWGOZv6RClHL1fmmzM80uB4tw/N6zHD5BrkmYU/kUc+Zxjtv8gNJ3X7/azhRtDIWC0ijCEzrkDnW5PGOJ2OcPlfIPrAfVsj9tXWpVYGCK9dkVcFCfF/TLym6VbbGAJrPWTAc+MDeAV+SBrSMIMIB8A9EcwxhNogvYNL2ib44urLo0hhIQh6uEp/glstM5M+rWmVRR14dYdp5E+xEXHl9HTL3mfUAd2J3eFA0V9d9mWr/pj6msqodFFHgdNder4yt7DPfHX8VCYjevoBCu8kIiSrdXOmtQFduzHx/OtqBPCeqEcwQhH92oxx2m/g+MU7cSeA2NxWQq9JebXLjyMc3BQF1tfE0vASK2UKZBzkY9BYkLPatGUHhXqWZfRCmbTCParHuyWXVguIrieseKuZ7jh7I2Mi1zEUqw4jPOlI7CcEazw0n4zsackpsXUmGbkCAOvPOmmcJrAkaZU6u4DPERVXFVpDKU+DCUcjaZlasOtOE5TNtJRBa+ug2eUbRVyGbU5NUbjG5P7yr4tNKsjNU26Lil1k7roQz8+UhNqRj76VuC+3gjrjldAo3s1kkb9Mm5VVIPlh8PP3mZh4as8QTq0pzTbiK5LyuD/+JML2C9//jN2/DQqkuaMIkCGntN6BiQi9Nqn81mKCY2qqhCLM3Ck1e/giA0Lmkyv2kuJAzYWivM9AoZkUxL5jVHsLHrqarwKvEI+ZPcBvDdVgzrjAOy4QtNYRUgYp5VYobk9LOCaTIoTqcpvXbh4HqepoRIhddCUkHJ5FAycFgZsD8XUGN27MfCV/at4Vlu1Camj/RwGrmnSO+uibmrPYDTCmjiacWT1I2YY6o7XkY1E94s9yvMYRg3HFcY0LIH1dOqZC87aBumPrkvKkF4RxQgMdYoGLsqQbpGh7WeA1zp45RSJMPWpQ7WKUC3IoF+aHlRTg8IOPTUV0o64l9YRcVLc7wGvdBbYRJOZ7CTwhFtOz2DeKD7BapXdjMWTzR7Vy6kEPNnw6i/J5yPxKtueFnJRurrT8MVVl0ZFVdi1YcgpHbxkhFG8gG0SFQsdXH6xwxVprQs39Li2qELe0M62CW8deKgqB5vacnkO+ZQlIcRKl4+Ksn8Kd7bVJgTXkYxbvyeZc0ddjEZ4LjcagslpvqJ8tbIX+3XH65D9y2YtF29UtFILGY895WgsUsF2E0fx6y9uGqJrkm7E8gzkOw2hFUq0dPMsLjjy+v3vf4+jumwY1T3noqUQ97ZQuOypQRKvq0h2ONdbH+MCESfF/TbEKKxopLR6bSvuP9DUB5kB7LAZicaHjUdOiWT24zSbzqApE/lQtDy2hxFePVcuVspGfyIe+2wnvHHVpJGoCxupCmM/HxhTOvKGdAKz7Gwp+R3sKLnuY1ba6o/jFTv+iaXvZPYjuTpNUVEuJQLKwaa2bB8FO2YhSurezgxgoU0h2pX949zRVpsSWEf7+QRIOo/JIHObmayuGtcFjZg2S6NTp1Wtwi+JtHqkQluOL+KIlT2WfbyFg6amdcdrEaO4isUbCn0RRxaPuYKYFrXE9eG0nG9JkvzYbLdwTI9wpNV/GUq8et0OJMkS1suFtLgT+p4XfRLlb/7uP8H5Nsmf2yJomSgtyHDd09qt6EW+0p5WFY5nWzjdIujiXx1R5wT/94//Gf727/4WVkvH8z8MwzBV4OiPLnp8j498VWjRzwzWzcTzzcwWS9SeRT4TpxN3I4gHsXsV4jNHXopurwt/+tOfoNORl9Zq6TsZn3gR+tSh72WOVcT9m4iT4mYYhmkMPXYBOJoJHHF/BcTzcOdFq8XLBUmBMgr/Mnoxyai5fBAcyIoVP73oYoy+rreuV7yeAcVJcTMMw9wDTfv9TCMwehfiV8pPIVpKkwpdKglY4bDgdn18vlytBqRl7eqh52bi1Wz0RdOHg76Mk+JmGIZhviKmaClIqxwjMMuhPl57ALmEXr4HsduRChYiXjRtKG9ENlxDj9D3wShOFjCGYZivT74KMaNiCtF0+CjiIebLSYhJk3tSJGBKxIp7YPVrnOj+lxJNipthGIb5OqiZPyVaZMzpxBoBeyYkJvRaJ3rJ7mTUg2sUft9LLQfVF3FcoGsYHZo+nI6HIB5+RvHiERjDMMwXJJsBpJ/uDQcj2VOY0vaNAkaob3TRNOIgukCnV/98FomWGLXViJAuYoO4m700OBVxMgzDMF8TEi8lXCRhOpmAyZFNJnY59v6jkJjQiIhELJlPoX+rf0MGjbzoYeTf/e53mY2bHgld1BGjr8VsKOKguFjAGIZhfk68I7Bn3v/SEZ84OZ1QHG8wnw2E4FRBbn/55RdhaFtBgqWg7ahzwTCPsE6GImxyS3G9CuPt36UPCJK9/soahnkdxkcdEfm2iLD2F+LWDr/tNMn/eziJj3lWPUrWvjR/DSqnENWw7ZnQVOBgMID9fi9GR6vFAOKu/+SYJQcYjFfCTBd7FFY5ojqjSJFwKfGilY0kXjTqorApjlfe+6JnKfIP5qkXqZ6ybxCJD+85vr/DMG9APLcU2P5KbunNE9oFWetxpLdJ/l/CHWX48TS3GBqr2FOHCkvAXjTssiDhIoHZbrdCZFbLCQzjo/OeGAkWfT9MGbrXpQtXB69Z4v5FhEEjHwqTwv7U1GHpjc8MwzDMfZB6adiDKucITC1XfCU0vUfPaR0OB7HUfZXMYTnuOYVMCRaZOLpi2jAT3RT6vVSM4JaLsQiDwqIwXzl16ENMHQ4SOELVy17lVMJ0K3/lVGPxIlCFMT1Ze9ycmqj0S1eGrmM+exxRDnN7NMZVZTYtstuI71HR9MecpkGsfIv01FyNiumTGn92nk339E0sK68i7dVTMt5yDMh4XR3a+OpF2uvpzMLNEqOm7wz/AeVpT/n58qq7FfWgv6TWqhMipK5sfHET9jEz7Oqy9qXXzH9dfYW1HTOd/vquKsPr1ZcGO82I75x0IOJUbqkeKK15vI/mT6b5Ged5U/TvUJKOuUZhlVOIr4ZGSaPRCCv2CpvNBgunI4RstxjCYnIRYkbTizTKItOP0KBoJdOrcENuCfJLYVBYnxp5idezpAnEkH00r+JVLbvZDGBNUwb0dmz98wqyIZgfJ4yNT0CI4/RtJ3Uc41RU+sVGG08O2fSmPCbw2SPp7gJjZU/fYaK3ulsN97g6Qi+bMl2N7M/Cn2C/O2qfjndDn62o8lfKM6Xl+Nj76arKMSTfVXVoU1Uv/flavOFefd9KfYwx1doPvV2dXrxalZ4qqvKqI6ax6E32NC1O7hxtuK6ubKriDq1XX1mHpFfRpL5squrPpipNwWmoOCdtSLwmKJZ52hZnLNPsVUeBhOTvGef5oygR00dhHxUwgqYQSXho5ESvfVptVvlSe1qpuFnPxBvlydC2WL2IIkVuyC35Ib8UxivveT0T/XtF9JXVOP/GFH3iwPoYX/YJj71oTXQcG8pWmyvvz7NPS9T5taY3R6s8DT77wWKpfVdJfovIbLjIeFa4oU89HHeQffUc2/UedseAj/VV+svyler3BzAtaBlv6Nu091BVjmH59tehTV29yLygA3TpcEtM9U9uSPelr+t6qc5rYxrVcVXcWV4D6jW8rP3cH0Zd/YXTJA2+c9IEy2mD/aSRthWKY7YdRGD+nnGePwElYmpi0RKwYr7RN2R7FSRK4/EYpuOpECKaEtztdkKk6HMo4pMouE126vVQ5Jb8fGrUdS/2x/jyDxJii9kAXpmpbzsJM8CrUulOHvc0lDq/2ddcaXrTuMD12WfQ1VkeHk2NWJh6kR/s22Ut+7TflT6i56bCn8hXXJzMCrSI7a/bhlJVjhnN8q3VoU1dvRDYqS/Ed6omsJkuSp1V/tFBBcaNqct2agjIazMa1HFV3A3qNbisK7g7jJD6CyQ4DTXnZA56xkv9Uhn2eg1uoQTm7znn+X3QWwT1NwmSNimtco7AlGPp8L2QMNEiDBKmGQ65FzO80lzisBUNbZMdHXv1KsPPkU1BWibsirnKL17dHnA/TbKPA6opAp89zZ1H1tRC/aWd+Irtbg+nazatENhz3uvv+dyX72rq61R1OiWxaiHtqat38cg5eQ++c9ICL+Tv0FEHzfP3iTaghEzXJ4eAyaO54n1CxX6tYOfVq7oyrDpe51eBV/sHuteAV3jqvovAthdXd9iw1SMCCH2CvBZsyGJ6ARt3o2kFnz9fvkT6HFfwiqqTu6qs7s23j5B6Oa1gRveCDgu4JpPS1GDps/a+0YuL0HbRhNA6ror73np9B3rbeUX5heI7VxWetJ3PNe31GfkLbQNPgTRIGRPPPTDpMFc6bTUI80KwwS6nZxzO61dcJ1itspu9ruPY+Ylphjq/+3lpOkJMC/jsEWOKQ3SyIR25nF7YrO1pBcdqKAOPP1++ZjRxP8vc4UkYHyFZKxcYl2PaL6eqHJH78u2hrl70vMQL2CZR+eb+ZqLVkcxbnOe9hpq8Oqm9P+SrY4uquIPqNZA77okV1LSd2vrz8EiaKs5JA5U2vb2gX7Ppvyh/vjaA9RtHceD92XswhSwTMNeaedMhYyJXUGHHRstln7h8lFYxbcX9kGI+eofNQzXf0vHBji6i3Md0v+hITkdk9uNUThH47LFhi85UzY3PABaBU2l0gxpOVzyxtG4IFaHuytrpD6F8pVjWRr4wncbChsMWptjRy+N7GOFopupOgLccH8i3j6p62c8HYlXhOstLf77AK9sEZloPMFhg2pbKL90n0xd11FPVZkpkN/CF2wqV89WVTVXc9fUaQGB6/dS3nar6c/JomnznpIPRKluVqtK2H8kXLOS8IH8ZoW3glXxLkuTHZruFY3qE9Fx+N2Gv24EkWcJ6uchsGKYGeoZl2SveUEKQHZ5clV+Cdfn7lUPLpJe9hp36O+C6ai3i4vq8qD7XnsGL28BssUTtWcBZvddQG2cNehHEgxi+ny/3D74ZpswJVssNxGPzCo7uI1Xf6HX7Y9oI1xXzxjZAwuV5scZ3GjK6qfDFMA7kGwEGkMTlKS560Nt3QVjlj2kXXFfMZ9uAqUvf5ov5j91un00hFq9wUk763YinEBmGYZi3oqYQT5fyra1hryunELP9HF3fXv0+RIZhGIYJgfQoN9m+Zxm9PKg2bteXrYlkGIZhGC9KtEykhSFgmmYxDMMwzMcQAydNjJSQ6fpUnkLUDurbDMMwDPNubNHSqZ1CZA1jGIZh3ohXwBiGYRjmk7gGUN1bsSaDBYxhGIb5ElwvFzhdi2eXWcAYhmGYL0mtgN14JQfDMAzTAvqR+VCzU8BYsxiGYZhPY38PRZ8+JAwBY+FiGIZh3kpkfYW/cgqRbpgxDMMwTFvQRYwXcTAMwzCtoxPVv+m+UsBI6Tod/iozwzAM0z4MAVNaxZrFMAzDfBwUI9Ij3eh5R2C5h3yfYRiGYT6NFDGpTCUBsxWOLELmIhmGYRjm6ZAmOUZSpFWWgElXYuTl8MAwDMMw74SkSJhMl4QRR5xTiMKp3FKuGIZhGKZlfL9ei1dzFNJFmHsMwzAM836UFpX16Huv28s2C1i2GIZhmLbjXIWo3ijFr5ZiGIZhPgm9UL4wUpeUNHmX0UtYwRiGYZj2QAKmKAkYHZMqV7i6XYsvYDIMwzDMu8hHXZlR0LYhYHRMOpCuxLbug2EYhmHehVd/pL1jClETL/qVPwzDMAzzNmjmr05/viVJ8mOz3cIxPcLhfEXhMgUs7nUgWcxgs95IC4Z5I7vjFXa7M1w65pdYmdfSvUUwHvdgHJsfEGSYdzGdTSFZruF4lmKkf95rMupDHA9YwJj2QuK1Op7hFvchirgjfSf0fGjneIJ5zCLGfAZdwOxvU1oCtkMBS2F/oqtcU8D63Q4sExYw5v1MkyOcxn2YdSPgt3G+F1q2tb5cob87wSaJpSXDvBESsEWyhhQvYm0mwx7Eg6FbwJR4ESxgzKcYLQ90qQVJByA2vyTOvJgjXvAm1A9s97BfDKUlw7wRNQI7pH4Bq3kOjGE+z638shjmxXCZM22BPqzsI0DAtOEYwzAMw7QES8DM6UP7xhnDfA5qmGzeZxjms+jfoSyNwrJPpfAUIsMwDNN6XFOJlQImPfC76ZnPor/WjHkPXOZMG7FFzBKwDn/EkmEYhmkFHYcg6SJWO4XIgsYwDMO0CznYcgqYLlouBWQYpmA/j6AbaWa4AvvJlfNqCN35IduTdPZz4X604q89MIyPKgkyBEw6pP+kuimP+moQhnkn9EqjqKWvQezAHuYoQNNjAimm85KZTZzAIJqDKVdEcV+pc1rBcLKB6faKAti+84vKnMqeYdqA0iNdl4hMwLQTKz9IG5pLhmEMdvMJbFGs0sMc9Od+RysUsekGJvN9ZmNCwjcbJABJCstRZskwTGPyEZiSMPHLusW0DGqXrTKdHew3ANPFHOiWsn18uEigt1nA+iT3FThGg9VwAicUrx2OvGx/bTEM8xX4fr4Us/VGwxUixk2ZYZzs97CFKYx8I6heDwZwhrN1MyxF0UrirRAvhmEe43vpMxX0/IcyDNMC6L7S9XprlTmjEWm7dJzHLxcpULeOTLtgM4HpJoZkNiq5b5uhMmeYNkBnj20U5ipETbRyx7prhmE0Gp4c0y2kdOtrMIPDjb+xxTB15PqTC1JmMkrL6I3jYkNzzTCMIIpi6EEqRisuOsc9Hu1Bv2sKVWe6hw0K2bw/ZRFjmFrw/HKeYvK9vYaAGe60nduVn1NhPgs1x1aZeAbJ9AzJeu88ftwlcJ4uYdTFEw33FbTdT1JxH2w+WQJ9LV35aZNhmLZBL5dXRlEagQm4BTNMLSREk80EBon5xNcp6cIU7VeLcWZj04PRDv0eExjTRzsZhimhBk62aF1vVQKmiRd54pd6Mq1ADQ1aZXowP+No6ogi1uvmZgpbSE8rGMA1d3tUU42a3/FhATEJ4HgNZ1ozkR9rgWGYFqD0h0RLGUFm7x6BIbriMQzjAYVotL2gYGnG8Qn+eHYo2fe6c1iT++0MevzsJcM40Udcimv2sLJXwBiGYRimzbCAMQzDMF8SFjDmS6DfnmHzesMwX4FKAXPNPTIMwzBMGzAFLLv04gUcTPuwxwhsXmsYpv3wFCLDMAzzJWEBYxiGYVpL1KEPFrlhAWNaSzd7V+AauuKVS2zeZ6jMCVUHDPNuOlEf/6t+QPLbfDH/sdvtIU2PsD/Ke1/6PbBB3IVlMofNepPZMMx72B2vsDqe4Rbzt7M+Qed4gnncg3HMIsa8n9liCYvFHA5p8VE9tbBwNh6CHA8sATvhQbz6IpSIsYAxn4REbLc7w6XD36d6JzTyGo9ZvJjP4RIwxWTUrxYwRdzrQLKYsYAxDMMwb0MJ2JHmtDVocKUErHwPjKYcrWlHMRfJMAzDMB8m6tL92Y64PeZfxJELmaVmDMMwDPMWUH+UFjmkqH4VIusXwzAM0wYsIft+vRY3x9Ux3Y3mlmEYhmFaw/det5dtEqZ8sXgxDMMwn8J4DIzWciiTUTmFaC1IZBiGYZi3IT68bImWjkfAbrnH7MvNDMMwDNMqHAKWiVcO7l9P2TbDMAzDvIvyCEq+ZEPqVEnAeMTFMAzDtAkSLWV0LAErqxcLGsMwDPNuaOaP9McWLfE+xEyYKhdxMAzDMEwb6AKOwLKX+SoqBcxWPoZhGIZ5NyReJ8dsYCZgcrG9e7qQ5xAZhmGY9nDNNIunEBmGYZgvCQsYwzAM02ou2RfCbbwCxve/GIZhmLYQdQoRi7JbWzwCYxiGYVqH6zuUfesFvSxgDMMwTCsxXuaL2FOJLGAMwzBMa5FfYC7QpxK9AlZ4siSQYRiGYd6ILWJqaPYtSZIfm+0O0jSFw+lSehas3+3AYbeF9HjIbApcc5Q+nvlC4CbxMgzDhPBIH/VIn6TivScMO83P6BvvLYdn98vDuAfxcAynS/lZ5FEcwWAwsAXsigJmOiah70UdbS6yGJHZ85MFdMAMxwxW3/EG4qUcb/Mw7qNckEwT3lVPzOto/zngfiFDud8o3BUeQv36adLGXZGZ/v1pJur969TlwVUezSgiCC8vP5Sey/UmjM0o7qKAxWUBI26Ugao8YOJQ0rIdjcxKHTPDEXvucEV4fshLcdxyWdo1LbJY6wl0xphQ+coy91SsDu5KG8veQecZZwCTY1+YNqW2T2gBXyGNwWTN39mf3ZNHDMbZZ2s82kZyAuIKI+u9HcnKBWy5XP5YbzawmM+hNxhDIXaZZwfexLmsS4EU4UrnD2RU86rS5E91Rs3hNlObt09ASVL1YCcP7Ysq0rbyzcKOaS95uwtofve00Wd0dk3S+HLs7FCalF1I+jK3rnJplE9HsVaVtQg7JNwqKtJ+H1aLwp0o6sAl3cFytYZvq9Xqx263g/PlAvtDCsdz4dzXGCsTpx/yFoY68GAmQ71703EfvnL5srw6O1hPRVUVO2b1mXvMp5CNwdkkLMtWngdtSJKrKVO6lH1dGi3/qr91lrcvrAanE4VvhF2XPoLCt9150m1T1W6kD+XP7XLQi2A0HECv24V/0Y/7ye0vN7hc/h/8y+ivoB/HcPnnf4a/4J8POub7+81f0N9ffkOOEIqeNv6CW7orZev++w3+BUGBhDgVaTGhotHjbPL3cYpifY55NRiHahK/UTvZfmGo3k0baQLbAvMAskHJM0KWegmjJ5FnTyX3ttF7q1vF1wbsPKl06dtVWGXg7XeMOrFQcdnGUb6lsK1dJy43nnTbf1XQ0SqXtB7j/+z/B/yvNIXor/4KR2Cb1Y9jehQH9/sUksUchuOJWPlxfdac6IsRSu8We4OnzfF+mq+ajayO8qry3OcKqErmyQQ1KeFIuqx1f28bbVr598bzFfCVxTPzbMfxjLDr6rAqDo9f1C0UrwjS/RaS5QoGgz5EuP9tvV3/OB1P0KF5xfMFDodUeKB7YuPJVGzXo6eoLvUMwzCvwtU7VvVJz1SDZxHShz6a7lfE0bTvt8P3+99tN7BcrcR2HEvxEgK22W+EgOEuXPGPROx6vcIR7b7CgIUXqzEMY0N91z19w6f7vNA0P5rOungeCf/RsG3/yn2/14WoK4WLDA26hICd0zNEPRQwFC6aZrtdb2KbUL8M05Tr5SoaHMO0DW6bXw8SLf23E3Xg/wOUaNDUHxe3GQAAAABJRU5ErkJggg==">


二、原因解析

    出现该现象的原因是PL/SQL Developer有限制查询出来结果集的最大值。


三、解决方法

    1、在PL/SQL Developer中设置,调大最大限制值

        TOOLS-- PREFERENCES-WINDOW TYPES -SQL WINDOW - MAXIMUM RESULT SET SIZE

    2、直接点击OK,不会影响结果。

向AI问一下细节

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。

AI