Technological recipes that I've held to prepare some solutions DBA environment. (by Felipe Donoso Bastias)

30 Oct 2007

Script que entrega cantidad de Filas en Oracle

Este script es útil a la hora de calcular las estadisticas para saber a que tablas es conveniente aplicar esto. Adjuntto script:

spool cantidad_de_filas.txt

SET SERVEROUTPUT ON
declare
v_ct number := 0 ;
v_sqlcode number := 0 ;
v_stmt varchar2(90) ;
cursor c_tbl is
select owner, table_name
from sys.dba_tables
where owner = 'SAMA'
and rownum < 11
;
r_tbl c_tbl%rowtype;
begin
open c_tbl;
loop
fetch c_tbl into r_tbl;
exit when c_tbl%notfound;
v_stmt := 'select count(*) from '||r_tbl.owner||'.'||r_tbl.table_name;
execute immediate v_stmt into v_ct;
v_sqlcode := SQLCODE;
if v_sqlcode = 0
then dbms_output.put_line('Table '||r_tbl.owner||'.'||
rpad(r_tbl.table_name,30)||
' count is '||to_char(v_ct,'999999999990')
);
else dbms_output.put_line('Bad return code'||v_sqlcode||
' on select of '||r_tbl.owner||
'.'||r_tbl.table_name
);
end if;
end loop;
close c_tbl;
end;
/
spool off
Share:

6 Comments:

xumeiqing said...

coach purses on sale
hermes outlet
chaussure louboutin
michael kors outlet online
adidas nmd black
reebok shoes
louboutin outlet
michael kors outlet clearance
rolex submariner
coach factory outlet online
lululemon athletica
asics running shoes
toms shoes
nike free runs
true religion outlet
armani outlet
vans store
canada goose jackets
coach factory outlet online
hermes belt
ray ban outlet
gucci borse
ray-ban sunglasses outlet
prada sunglasses wholesale
nhl jerseys wholesale
ghd
polo ralph lauren outlet
michael kors uk
nike air max 95
adidas shoes
polo ralph lauren outlet
coach factory outlet
burberry outlet stores
polo ralph lauren
kate spade outlet
coach outlet online
vans outlet store
oakley sunglasses
cheap ray bans
under armour outlet store
chenzhen20160511

Abel Ahar said...

Here we present to introduce to all visitors in this great blog. and thank you for allowing me .

cara menggugurkan kandungan
obat aborsi
tanda tanda kehamilan

Felipe Rodrigo Donoso Bastias said...

Thanks Abel : )

gondes ribut said...

This is a very good article material and it is very useful for us all. thank you . obat penggugur kandungan

sendul said...

By reading this article I get a lot of lessons and this is very useful . cara menggugurkan hamil

anggita nirbaya said...

By taking the time to read a lot of information like this to add my insight . cara menggugurkan kandungan dengan cepat

Copyright © DBA TIPS | Powered by Blogger
Design by SimpleWpThemes | Blogger Theme by NewBloggerThemes.com | Free Blogger Templates