Oracle数据库中有关记录个数的查询

时间:2022-02-22 08:37:20

一、查询表中全部的记录个数

可用两种方法,一种是在oracle的系统表中统计,另一种需要写存储过程统计,方法分别如下。

1、系统表中统计:

SELECT sum(num_rows) FROM user_tables;

结果:

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAATgAAACiCAIAAABal0asAAAI70lEQVR4nO2dPZKjPBBAOTpHmXxroz3AOOQSjr5kQhUX8BfIg2X9NA3IRm29V9QUK0MjN3pIAlw73ACgeYazKwAA6yAqgAEQFcAAiApgAEQFMACiAhjgLuqfv/9YWFiUy5mivv/YAKDkA0UdhvHsKuRptmJ2GYZhGLqYvn2aqI3L0Hj1XkSq0/BL9cifSl7UYRyXJfpnVJLdZSlfjVP/+7Rtglw9Ic/ZVAvrrZHVCVH1ZESN2sTqSmnjNE76ty6NW+pZdVVeyWY1Wnk/q7Yg6kFWRI0Ksw6Xtik1mtc1po8RVbhWImoUoV9Rb7lTnh2AxbGScW/+kGuNKTv8S1cylQwcGALCknRFPtnpXlH57bfBhX+F4MrRb6lkn6jZb5GtoZwxIbgQJ9wm2rFUTzFyfJZLFfskpJtJpbFr+ml2myOilkrkIXTkQCRSupIVLFOfcgsT4pQC7utRZVGzO6bforQib6MxQc5P6aD6vYTjIurtJlq3WnJk6Fvqvc8StVSS9k7RZrl910XNlhyc+ZdUkXswpQalvnGrqKs9c/YomhpaJyPqjptJ2at+qfvVz6PkGyrZphmNi+SVuqKWgpSGbfljvVdU/Ucr1a7ao67GD8u7FjWdF2XnjcIS7ZgGl+okPpMI63BLmuZiQnhtji7t0ZVbFjXbVd6SJpIGKfQPqi+eLUmTHxWG/5S/S5iWbA8WbSDUOd1LPlb6aeno5RqO0far1fsAMqJap9l7v81WzBaICvGVvpNGoKe1/LRQh/eAqGAYRAWAhkBUAAMgKoABEBXAAIgKYABEBTAAogIYAFEBDICoAAZAVAADICqAARAVwACICmAARAUwAKICGABRAQyAqAAGQFQAAyAqgAEQFcAAiApgAEQFMACiAhgAUQEMgKgABkBUAAMgKoABEBXAAIgKYABEBTAAogIYAFEBDICoAAZAVAADICqAARAVwACICmAARAUwAKICGABRAQyAqAAGQFQAAyAqgAEQFcAAiApgAEQFMACiAhgAUQEMgKgABkBUAAMgKoABHqKysLAol9NE/QIANaeJ6gBAzWminn2FArDEaaKefYUCsMRpogJAy9CjAmwGUQEMgKgABkBUAAMgKoABEBXAAIgKYABEBTAAojrnnH9F6+xafAJksiJhMhHVOZpXPchkRRA1huZVCzJZEUSNoXnVgkxuZZqm+c4UfWRD1GELv7t870sWzasWZHIToaWGRY32FAqdc8Pw7Zcd+aJ5bWJKmtQCmdQTWTpN12gDS6KGJeM4lgp/d3lHj5rtzPthmqfpOk3XvKurmZx0aCtTNdpCenKrn+5pmn5+fkJLr1dEXUMv6jAMl2e6cnWxNL38e1Yzeb1e7/bMuWWafJtV1qdutAXfzCJRo5Ij3Ct8d/VuKaKuoxR1HMdxHL2cnsvl4gv3HdcWD0sPiOoEu3Z5VTea56U9qq/q/Kjk3dK050fUGKWo3szo/B3vVHeP0N6JxlKnzmTGrgNe1Y2WTm0qTnaeLL0nc8pa6gyJ6n47sQWh8AgNiDq3LKrSUrdlEvFk1wGvqkdbRrmhqFGJwDzPxY+mafb1C2YQU8FSZ0hUPd/BshpZzohcpQ5F1Vvq7N9MUrY3IUIo6tO670rn+e7qmqXOkKjRnkLh1tQLGdkUR3nysjy3pXlfwypE29lM0+cumyx1xm8m+fN4CzrP5X5EWCifbv+8ZVm5rweWPvpV0VJnS9SwZPccdTXFq81rSG72pmx1VWhfm+LUinZ3MnB1q6XO+M2kiqKGOOfufs53S+dpvk4rlroORXVrd+00okazYs+RqXJrPerDyXlyuyx1xm8mlZw8KGrg58PSq+K89CiqE0fIW3vU8Ip7/IHqIuq+3WsxTdfQ1cf6C0R1Td5MSv0ccnd9d4h6vV63Wuq6FVWZkVJllp5z0dKvHL/53IioLnJ1u6Vu4zteD7uOWVor2iDe3ZU/Xcj3qPPsH5X6RVkfM6K6LY9nXvqub9R5+oMu0tboUXeOeKsTu7rFUrf9XV9v13FLq0R7qajLfFWPGVH1/O7ywhcelk41ErXWs9x2eLi60VK366X8g5YKk/Otlz95cKsf+i4roZxbLXVWRM2y7zHpKvrnqEPuXd9PstTj+9MdO77/1zPXNd5ZGVd+jroDM6KmPWQq6u5etJQRRa1UV9Y+4WduFbEh6vPrRvfJ5/fzdPTIvLSUETgCmayIDVFdqz0qCJDJipgR9W3QvGpBJiuCqDE0r1qQyYogagzNqxZksiKICmCMJkT98/cfCwuLsLQi6vvrAQACR0Udx7FibepGs8imYRXp6gdJVM1g3beVnSP9F0dr9kUluWLKDHx9fSFqP3ysqM1a6hGqp8wAonZF06JGL/E+/zQn81HY+qMtXeGt4NU4pcpEheFBw7/CjqUkKPOJqF3Rrqgl68KVrMMu0aC0+2qciKyQaUlWV6FWEcp8ImpX2BB1YbeoaS+nibN69OgjWdRStAhlPhG1K9oV1eW0OV3UdKAbxXGJoqWYiAp6mhbVI4yBNw0ys47t6AMFUV0ic6lKwoGU+UTUrjAgqhN7Qvd2UeUjCkFKo4MIZT4RtSvaFVXQwCkE0+yuiZONqRe1dPkQjqLMJ6J2RdOiZoeR6XwyO73MjkWjDTRxou3TXbLHTY+u7E4dokKOdkU9jiDDucgVU2YAUbvik0U9wpDwtkMrM4CoXVEUdYS2QdSuaOvXM0Py/ziCwOVyObsK8Ca0Q9/S2M+L+l8lEHUTiNoPG0TNuoqoJ4Ko/bBN1NTVfaIOw4CoWZY8pyVpchC1HzaLGrm6Q1QfBFFTIj+FTz2I2g97RA1dpUetiCBqNjOI2g87RV1cRdRXoOlOb4jaE/SozaG09IaoPXHCHBVRBbIZQFTgrm9DlL4+osIJz1EX5xE1IppfhOXZ7RG1H3gzyTCI2g91fj2DqKeAqP3Q1q9nhmG4wBZObTzwPvhPogAMgKgABkBUAAMgKoABEBXAAIgKYABEBTAAogIYAFEBDICoAAZAVAADICqAARAVwACICmAARAUwAKICGABRAQyAqAAG+B8F7GfhcBbYdQAAAABJRU5ErkJggg==" alt="" />

2、存储过程统计,代码如下:

declare
v_tName varchar(50);
v_sqlanalyze varchar(500);
v_num number;
v_sql varchar(500);
cursor c1
is
select table_name from user_tables;
begin
open c1;
loop
fetch c1 into v_tName;
if c1%found then v_sqlanalyze :='analyze table '||v_tName||' estimate statistics';
execute immediate v_sqlanalyze;
v_sql := 'select NUM_ROWS from user_tables where table_name =upper('''||v_tName||''')'; execute immediate v_sql into v_num;
dbms_output.put_line('表名: '||v_tName||' 行数: '||v_num);
else
exit;
end if;
end loop;
end;

输出结果

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAXsAAAC6CAIAAADAn3r5AAAO9ElEQVR4nO2cS3LkuBFAeae+hO6iG/hKnll5o6vMchRhLybGtlbawgtNlynkB5kgiOLnvejoIEEQBCjlYwJF1VIAAGaxPLsDAHAjMA4AzAPjAMA8llLKx4rfjsSzb47Os+/KX3wAHIBs+CjGeVbXK347sHGefW8O9GOCm5MNn7MaZ1kWZ9evvJEj3KIj9AHg457G+dp2HGRt93GEW3SEPgB83ME4y4oSM8sE4yzL4uwGS+JHj/NjgpuTDZ/zGaesrPGQjhTQc40TKcE4cAGy4RMyzjqtqErU3SE4OU5EHItN9h5VyFu0Hri8nDVAVUkW8uZsu7sAY8iGT9s4VTipJR+tZ3IHkVmVlIgqlO2WWVPdIvUORO4GOQ5cgGz45IwjS+Yb569+rzId+b9aeRTSOFUaIu+JmqqodyyS4HxgHDgM2fBJzKrWu3J7vnGqHMfxjr+bxV/HcbTyyBAjTiHHgVOQDZ/EyrE/fZg/qyrhTGdv41Q3xLKJn+OoJrKshHHgIGTDJ/dZVfWU/jjArOrpOY6UwvrOxI0jDzkVMA4chGz4bFo5lmEmt7vJruNU5T7Z27SmGe2WL4KOjtxSjAMHIRs+IePIxF4+1Z0pQB8dxgnaZA/jWDmOVUetYNWRNTEOHIRs+Gx6A3CUXFTO8peclkeys6pHO5FUCOPAQciGzynfOX4ukcX1x65jZGdW1WznOD8muDnZ8ME4aY5wi47QB4APjDOBI9yiI/QB4GOLcbZ9I90u7KCLATz7rgAciGz4fDPODuEJAPB/MA4AzAPjAMA8MA4AzAPjAMA8MA4AzAPjAMA82sb59WzMvYGH4G+359k/AYgSMs7v5+G2xnl2F57JzYd/LjDOFbhYyGXfsr/Y8K/NJOMsyzKwmsMW46jfm+N/587Gr9oJttCsc7GQ+/j4+OWXX5qu+apTNg//R4xBg7s7uxjnSxzKV+/9ZH1UnvVc41RdrY6qp1QlDpEWOupc0jj/bTHQON11gk+j7U+my7BXjlOJQ3qk8otUTx/dxllWXyRYjF+X5fuXDao2yf5u7WGcqr5qz46SaXwZ59/fWZalKnm6cZo3p/u34sLsO6tSI1Max/LRNOOoupHqsepbLainBMtTddYhJ8VRbfeVzOTLOH+uePzyrAsnGOf9/f3l5eXt7U3Wif+Ii50435CnreOs7fO7cFP3hbqN8/hVUC0p68c35LZP5CoVTo5zXuP88ZPq/jzK9zbOl25eX18/Pz+rOtY9UcubP75b8eR1HPXELQxcOXZ+P1Ki8X/PUlex6l/SOP9qsatx1rqp6kSeGfL5UTBOKWXvdRzHKcv3WZVqpZnGWYe3+jtkVbY21F21HbWOb42KSxonwijjvL29vby8vL+/f5VUuimBdZzI4wHjlIOs40gfdbN9VvUosWoW10p+9FqtWYfUzsj6GGfL5X78+PH5+fn6+volHambkjGOVcGqczd2N45VsmifVakaSjHkDUArwYmkNpFnXbNCardc1DiTPx1/SEfqpmwzjvN8uiG7z6okjwqVbtSNmcZZB5tvkOoUq5FITafx4NGifVZVNT6kZBpfxvnPT6rfn0f58HWcL+lI3RTNOM3HQLDO3dhx5VgVhy+XZxnnEVoy5JonNku2n5gyzgU4zqfjTh3LJvJB4j+07sbUWZWa16hHu9k+q6qe7b53VHE4+A3KQ8FE45LG+eM7y+pz8Tmfjjt1nAeG89DCOGVv48yHv+S8AF/G+WeLZ/1dlf/AcBSDcQrGuQaXNM60z6pgJhjnClws5Jp/Nb6mXG741yZknHMx9wYegpuH3M2Hfy7axoHjs+83ep6BZ/8EIArGAYB5YBwAmAfGAYB5YBwAmAfGAYB5YBwAmIdunL//+g/+8Y9//Gv+G2acEToDAPhG2jgdX+BwcCId5i+AAYZwd+NU30ph/fmv/B8AOggZx//Cl2bNTf0zvl+majxSR2083o2Os1LNAtyBkTmOemi7cYpILqqNvpREtqbW8ZW3cWgYB+5G1DjN5EUNbxlRfWHmX6vplGbL/uiqZMrq0vZxAVyevdZxrAgcZRxHCqmuNs+Sw7HcinEAmrSNoz7/rUyn9MZeo5eBfMqq5rfpN6JaxjqxA4wDdyOX4/jBFrdSupdhlai+iLccKcE4AN0kjFM98NfbD61YM6n19vbZhzPBGWsc1ZvMqgC6ya0cr3dLLEEom40jA76ygJpMBdOrYEYjR6F2MjGqcA8BrkR0HafEPiFaDHYdwxYi0gzaFgCa5GZVzalEM8c5Gn5aVOVWsv6sbgJchPSn4wAA3ez1Ps6JiHSY1AZgCHc3jrMgva6grmQBQJaQcaz1YGuRdeCysWxHNh6pYzUe70bHWdmWAS7PyBxHPbQ9oqq128hGJCWR56p1IoLrZkgjACci9z6Okzuo4S3DqSPGfK1YddSrW437o6uyJ7XxPndgHLgbe63jWLE0yjiqFJq+i3TGMqnjO6up5tUjnQS4EtE3AB3qFkc/t1M5jnqi06xvHPWKQ0xh5UoA1yaX4/jBFrdSroutGY3Vpch1I01ZWU+zcf+6o+4PwIlIGEcN+GrS0Yz87tlHcMO6brNxp7eVF9SRdosD3cCtyK0cr3dLLEEo24yjBnxVqGYKwfQhmNHIUaj9jI4q2UmAyxBdxynCMpZcVHYdwxYi0gzaFgCa5GZVzalEM8c5GjL/sjIyKZojjwvgmKQ/HQcA6Gav93EOS6R7JDIAO3Ev4zjLz+sK6roVAGwnZBxrPdhaZB24bOxcN3uteE92ynHUpjAa3IqROc5OESXXbqsNWafZiFXH99rGUViC3tIswLnIvY/jJBSLNgcZEmNVy33GqZpyxhJpts8UGAdgr3UcK5b6jFNZQDVOs2Ury/A7b5l0u3HUlgGuTfQNQIe6xdHP7Soy17vB1EbWr8qrbXmJISNyrgVwE3I5jh9+cSvluminBtm4beY4/uU2Uhln1P0BOBG5d46rjbIKSCcyZaTluhhIPYYYR7WAOq4+TTRvDsDlya0cr3dLLGUo24xjZUxr08UzhWBGI/us9io+inVXm4UAFya6jlNiaYUqiONEVESRQbcCQAe5WVVzcnHwiYPMtqz8S4rmOKMAOC/pT8cBALrZ632cU5NdErrAkAHmgHFq1hMrdSlKrmqdfcgA0wgZx1oPtpZdBy4bWzFfrbk8Il/WV486l4t3rOOsZpvb7xjAkRmZ46iHtsfPEljNbW5EBCHPVetIrw3R6x4KAzgaufdxnORFBrbcLauMI9HFmHGqo85Zkcv5413vWp7KjhTjwB3Yax3Hirc+46gRXjLGCV5arWO51ZcaxgGQRN8AdKhbzDul0cXwrCqYevgX8o2jdsY6MQXGgTuQy3H80IpbKdfFocZx+h+vb2U9/kB8MA7cgYRx1BiuQl0Nlap+NpzixnE24vHczHGkSdWxZ0eKceAO5FaO17ulFZxqYUccykRJBryqPLVO8+rBjEZeS+15a3zKKegGLkx0HacIy1hyUdl1DGOJaDToXwCoyM2qmhOHZo5zfJxkqoi8Sdaf1U2AU5JbOQYA2ELaOB3rIDchMnASIrg5GGcM6hK1tdbDug/clpBxrPVga0l17LKxE8BVBetEqxGrnaY+5IXiY+k4y29w4K0G2JuROY56aGMYOJbxr7K2hrXhtOOf5Z+i1pFqGGIKLAPnIvc+jvNEfUSRLJTtJPpnx3lKQMU2jtpOtdHss5SIvEvrXctTo+4PwDHZax3HipyOR3rEbkHjqH5pGqfZZ7WC1WffZR3GifQQ4CBE3wB0qFvc57c/aIpqd91J66ymcWT78lq+cdTWmi1HcG4CwAHJ5Th+kMSt1NlXbUG3OiR3LYn47VgtN/sWLxliHP+KAEcjYRw1CB9h48RPVT8VGHF3yC7Fz0ptNPupdsmym9TQ9vsDcFhyK8fr3dIKM7WwI6JkoKpJSrCm02az3O+nX6KaSz0rK45I9wAOQnQdp9i5w7fmXAVcmKZxStjaABcmN6uSz23rSd4svBiLyONkybqmn+kAXJXcyjEAwBbSxmk+kC/wxI4MgSQFoAOMU9NcNparWmcfMsA0Qsax1oOtxdGBy8ayKbXxSJ0yVJd75DhD7hjAkRmZ46iHthuniFSi2ggmIM1glu2rdXwJdo2yvijSgauSex/HSV5k8MvdEgh7vZfutawG1asHr+WPd71rdWOLgDAOXJW91nGseBtlHEcBTlcjnW+eJQdo2bZvpOgGLkz0DUCHusUdYiaST1nV/JJss6plrBO7QTpwVXI5jh9acSulexl4z1Ae6shxgmcFDdgNxoGrkjBO9Xhfbz+0ooZKc/rT7qVhHHnRvY2jmlQde3akfs8BrkFu5Xi9W8IhvdE4MryrmFeTqUiJdTm/xDGv7HZkgNkeApyX6DpOiX1CtBjsOoaxRDQa9C8AVORmVc2JQzPHOT6RRGld0890AGBN+tNxAIBu9nof59REhkBqA9ABxqlxlqjXFdS1LQDwCRnHWg+2llQHLhtX6yaPCF83Li9nmaLZpXhv98hxhtwxgCMzMsdRD22PnyWwUtvciAhCnqvWCQouyx4KAzgaufdxnORFBrbcfbST66L7op11KHKWczl/vOtdy1PZkWIcuAN7reNY8bbdOGojlhQsTTjXUi0pd6V0MA5Ak+gbgA51i3mnNLpoJxHVtl+iNiIP+aeolrFOTIFx4A7kchw/tOJWynXRXl7ZeMi/XLwE4wAESRhHjeFqiqGGSnZq41/XyTicjXg8N3McaVJ17NmRYhy4A7mV4/VuaQWnWtiX8lThLQO+KlS3gwlXMKOR43L6nBomuoELE13HKcIyllxUdh3DWCIaDfoXACpys6rmxKGZ4xwfmZFZOZoUzblGCjCf9KfjAADdJGZVAAAbwTgAMA+MAwDzwDgAMA+MAwDzwDgAMA+MAwDzwDgAMA+MAwDzwDgAMA+MAwDzwDgAMA+MAwDz4G/HAWAeGAcA5oFxAGAeGAcA5oFxAGAeGAcA5oFxAGAeGAcA5oFxAGAeGAcA5oFxAGAeGAcA5oFxAGAeGAcA5oFxAGAeGAcA5oFxAGAeGAcA5sHXiQLAPDAOAMwD4wDAPDAOAMwD4wDAPDAOAMzjf6sj0lQXHU5MAAAAAElFTkSuQmCC" alt="" />

二、按照条件查询记录个数

Select Count(*) from tablename where ID>1

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAbIAAADFCAIAAAC+QeCGAAANl0lEQVR4nO3cPY/ruBmGYf6M/Fy3Bzjt6adfbLX14kypaoMEQRAkcJXmAJsgWs9HMTOAU9Dm8OWXSIq2JOq+IBiyLMmURD/zSrJHffn67bxKX75+Y/CHEcCNqTXH4sc66DxauhUfHx8fxCJwB6uOxdMKfFixuIaWLN1hgP4RixOIRWBvUrGoLM6U4NPmsfiHRymVeJqeuc77+7uOxff394r25EwpasnSHQboXzQW7bDT4/4UZ2LzWAw0Vyln3J4SnMEfL2LHYro9mVNmtqRuWQD5smLRn3KfWPyfxS5d9VP7paLxInYsOi8563fEVjizJUt3GKB/0yfRC8bifyWllD1iAsh/KT1e5O3tTcfi29tbojH57zKzJUt3GKB/07dcggl4n1j8j0UpZR4T/KrNSC8YY8di8I2cFjoj/lvPbMnSHQboX9adaHNt0dSP94nF3y3BpLNf/d0TnFjKjsXEWzjv5bct3f78lizdYYD+1dxyMeEYnK1hLB49SqnEY3DmmV5fX3Usvr6+JtbvR16sGdWt0i1ZusMA/UvFol0eOhP9eZw5m8TivzzO2+kpzqM9c+JpJjsWYy2x1++3pEkzTEuW7jBA/2q+zt08AYO+fP32T4vJID2eeLQXSTzNZMdies5gG/zpdc0wLVm6wwD9W/WvXP7hUUrpR82eYh6dmWNPM728vOhYfHl5CbbHrDbYBmee6maYlizdYYD+rToW/+ZRSjmPzvQ0f4WTnp+fdSw+Pz87LfEbkGhb7GlpS5buMED/Vh2Lf/UopZxHPWLGE3Lm8dmxmLnmdHvqmmFasnSHAfq36lj8ywo8PT3pWHx6elpDS5buMED/Vh2Lf14BOxbX0JKlOwzQv1XHIgMDA8P9h/XGIgAsglgEAIFYBABBxOJPP//CwMDAsPPBjcUlohkAVoRYrJfzw/DY723Sa7vDT84BxOw9FpU6FE33Zgv/M6HMpeyn/iO2IrO3YCtmxaI6HPTQulV3YvdmP4iq+7qfererFpsfArt5Oc0OzulPzH33m3Wnuhb6S8UWcXqLUpcBW9SgWqzrx/cM0+B7OZkY7MF1yVhULQajJzNQbpcgkyPBRfzH9FLhVd1yo+pa6CVgeG+Y3mJPJhm3iFg0T0MLxmMxEVvBYiTIWZu/eMV2zVcRi/6rRVEoVnLLjlHXwsxYPF87DLG4dalYNCdodk/1T3P8fhycx56YeeqXfncz7owEFwk0cl4sXmcouLY4WWo5n7fJUtHeNH/Eni24SGKjnA3JKV39BmdWu/bjOXK80sfdn6dVC2NLBadfJx6Ixa2biEV3bqtrxmbz58lZKtCyjPXMea/msZieITYejMKcWDyH9nz6WARjKGejMgurdO0ceCkSizkjk72uSQuDM1Atdm/iJDpWeaVj0a8NA2+cHYv+lA3FonnJLrhCH6fAB68iFmMzLBiL6cUT3SlR5MZOUHIK4dIW+q/GdgvXFruRdW2xKOASH87JiZnrWVssTp8txmvA4Nl3B7EYGw+2cDIWg0ulp7Rqof9qcLfEvtVALG5R5bVF++JOep7YFDMx1bi8K5v+4M8ZfC/7z7vybkbn3IaOFYA558uJGfx5Am8d2t5YGWXGncfEFpnx/AuLsWXTW2E3JnYE87c0HfelLfT3QHApv6sEexS2gq9zx9KhrPoIJp334RHj6af+OgHcx95jsaF0bRWrSpz65eyl583aW095lm5RG71uF0oRiwAgEIsAIBCLACAQiwAgEIsAIBCLACAQiwAgEIsAIBCLACAQiwAgEIsAIBCLACAQiwAgEIsAIBCLACAQiwAgEIsAIBCLACAQiwAgEIsAIBCLACAQiwAgEIsAIBCLACAQiwAgEIsAIBCLACAQiwAgEIsAIBCLACAQiwAgEIsAIBCLACAQiwAgEIsAIBCLACAQiwAgEIsAIBCLACAQiwAgEIsAIBCLACAQiwAgEIsAIBCLACAQiwAgEIsAIBCLACAQiwAgEIsAIBCLACAQiwAguLHIwMDAsPNBxOIDAOyeiMURAHaPahEABKpFABBELAIAqBYBQCAWAUAgFgFAIBYBQCAWAUAgFgFAIBYBQCAWAUBYbyw+PDysrUkbxZ5crT0fmjtse/VbEIv9Y0+u1p4PDbFYY889pi325Grt+dAQizX23GPaYk8uaxiG08XgvLTnQ9NPLKoS10W+VzRr3HePaYs9uSA7E4lFW1exeJYSE8dxVOq7HipatuceU2HwPnIGe3IpTiYOw9GZYc+HZs62K3Wwh+ZvUROL9pTD4RCbeF3kHtVisFDdj+E0DMdhOIaTcXJPDnlyG9N0bTfid5XmnWcYhh8/ftiZeDzOjcWeuvfMWDSpVR2LqVPdDmJRKfUoddN1cphM9IsRbXJPHo/HS1adQsMw6M90Znvaru1GdKd1YtGZMsdl8y/JeMnEObGoP63nsz4J66F715dySjWpFpVSv/76J6XU33/7zRk2H4uHw+FwOOgo1B4fH/XEuvfdls9MnBGLYyLLqlKs7doM3a80c3zrMuKm1aLe8NPnJl8y0a+Rcw7NNRDP5/PnYwfJWBeLRRu+31jUOej07/kF40rO9dJyMnHM3pOBLJuRYm3XNkZOeeyeVr2q4JRqIhMvh2YIZuKYd5Znp+GcZLz1xY3SI5v9AQ8UhqurFsdrgWYkJs6xglg8rTkWMzNxLPmzLLJs9tluw7WZOlEXiXbZWBeLOlbsWHSmJJxOp+hLw3DSW2td2RgimTgmD41fIVoNrNl2fTiu1zoDj3MOkF550eL5sWhfRjR/EJtcW2wWi/m+W8Pkmks3yW7SDmMxPxPHLm652Jmo2clYsapJiTXYsSjGdZl4Ol2ScSoTx4zPrV8hni0Nk3F+JpauJPsCwmED1eJZSkyc2tqJjph/2aWucwfJT+6p+mMcWltlKPjfvCnKxLGLWy7O0aw+ynp+u+4yV6X9Yiy2Ev2NGzNyGbcy8bNmTGbimFEtOsnox2Lp2XQwGZtkYumqJrtlxee36C0ax6I9pfra4mQXzNlrj1NK92zi01y0nlZruySglYylmTh2ccul7o9cbD1NYtE2juMlDU+XTDwNp+MwkYljXrVoktFpp9Pg/J1QHWSTqypaob/t+YVhw2pRJ6NrwVsu6SOaE4vO1UxtziXOtVWLnwl4GsaqTBy7uOWiD+X8bxfEEnBmLFpp+JmJx4yjnFktmvYo78zMlI1F+6HutDe2krpT8mAsWltkPtGH81nfd1K3uLYYHBa+E504nKXVounNTb7AaGKxbvFWhuFoJ+Pn+A1icVzxLZcxdHmxeiV+/MWmBwVT8Xg8lmbiWFYthotEVX4erVXcJPEXD2ZiZjJSLdYoqhZNCOqR+TfEVxKLo5OM5Zk4Fn5B7DPLWnzpuuHanJvRdZxYKXrVCFeLp5P+aqIeMtuzVLWozTkiiTOhzLOilVxbbBOLY8kXdG76m2glC0NzntWuWiw4270pNxlLMnEs/97szDripmubeTZ901g01xnzLVgtLm7Onegmb9EyFvNdF7nh17nVtWB0YrHVdyfX4zMZCzNxrPo5wcwUm1NE3FSwi2a+apjsc6KwNBPHvL/9t6sWl1X3vcWGb9EsFoPqvpY4Kf97iyr0m+gtdpQ0XStWLHj/f9NynHLPxjR3inxvsULm3367WkxXIRsy51curd4iujdLY9Gv/vxYrK4QbfwHnVb2/N+rVq7ob/8d2nNPPf2/xe/OMF5jMfjSHHyYW2FPrtaeD00/sTiutVpEAntytfZ8aLqKxbvZc49piz25Wns+NMRijT33mLbYk6u150NDLNbYc49piz25Wns+NMQiAGwGsQgAArEIAEI0Fn/6+RcGBgaGHQ6pWDwDwP60icXD4TA900JrqzOOY/7Ma2gwgFamYzHnVFznQuV5/NTacn4Nmv/7eXties2ZW/Tw8EAsAj3ZQCyOVn4V/UsIZwZ1/ddMzmNM5hYRi0BnthGLQX7qUS0CmK+fWEzPEEzMdIBmbhGxCHRm7bGYU/fFLiz6y9pP/RFH5hYRi0Bn1h6LWtG1xfR0PxmJRQC27cVicJHYFcNYbZhz4yVzi4hFoDOdxOIoi8FY3jlTiEUAvi3FYuLE2ZltDCWgf/ZNLALwbSYWY2Hnj8dKy+D0RM5mbhGxCHRmM7HojNhP/dvN9nj6qb9OI3OLiEWgM9uIRVv6ZnTsRDt97hxcJHOLiEWgMxOxeMAUYhHozBr/g45SquHa7uDx8XHpJgBopuwkOnYZTsfivxshFgEsqDgWg8lILC7dBADN1MSin4x1saiU2lAsmm33XyIWgZ5UxqKTjBWxqFeylVi0m+Q3j1gEelIfi3Yydl8tEovAfsyKRZOMxOJ9mwPghqgWsxCLwH4sdm2RWASwTtyJzkIsAvux2PcWTcJuIhbPfEEH2A1+5dIAsQj0pOV/0CEWAXRgjf9BRyn1uDXLHUEAjbX5DzoA0A1iEQAEYhEABGIRAARiEQAEYhEABGIRAARiEQAEYhEABGIRAARiEQAEYhEABGIRAARiEQAEYhEABGIRAARiEQAEYhEABGIRAARiEQAEYhEABGIRAARiEQAEYhEABGIRAARiEQAEYhEABGIRAARiEQAEYhEABGIRAARiEQAEYhEABGIRAARiEQAEYhEAhP8Dt76XQ/GNEHcAAAAASUVORK5CYII=" alt="" />

三、查询一个用户下所有表的记录总条数

declare
v_count number(10);
t_count number(10) default 0;
cursor t_cur is
select table_name
from user_tables;
begin
for t_rec in t_cur
loop
execute immediate 'select count(*) from '||t_rec.table_name||' into v_count';
t_count:=v_count+t_count;
end loop;
dbms_output.put_line(to_char(t_count));
end;

参考文章

1. badkano. 如何在oracle数据库中查询记录总条数

2. fight2009, owl1230. oracle数据库中如何查询一个用户下所有表的记录总条数