0 then &gL &@';,
Response.Write 错误 : & err.description & vF ,iHzv
response.end WTcrfs)T
End if _s_%}8o
End Sub k7gm)}RKcu
Sub EndDB() QIMoe'p
Set objOraDB = Nothing Rn-RMD{dh
Set objOraSession = Nothing fv",4L
End Sub UpU2H4
Function getTableList(str) >; A7mi/
Dim strSql,strTmp hZobFf
Dim objRs oe8sixZ[
strSql = Select at.table_name as tname,au.username as uname from all_tables at,all_users au Where au.username=at.owner order by au.username AGe\PCn-
Set objRs = objOraDb.DbCreateDynaset(strSql,0) dSkW[r9Z%l
While Not objRs.Eof n^Uu6
strA = objRs(uname) & . & objRs(tname) 1 %nE
m*d {pX
If str=strA then f;nO$h[Qb
strTmp = strTmp & & strA & JAK+v
Else gJ8+HV
strTmp = strTmp & & strA & d,_Ky#K5b
End if O7_u9lz2
objRs.MoveNext : ;nvqb d
Wend 1$*ZN4
Set objRs = Nothing <=D\Ckmb
getTableList = strTmp XPhC*r
End Function Sl8A=Ez
% > 7( &\)qf=n
mP@<UjxI
vt`V<3
f+/AD
R*l#[D5A
All Tables : W]]@pbG"H\
=q%Q^
6i6m*=h
W_%p'8,
Eu4-=2!4
() I,*zZNvRi
ID-Y*
g/o@,_
Y~P1r]piB
"h-G=vo,kl
zT\nj&7
then `Dck$
strSql = Select * from & tblname 5cv&`h8uo_
Set Rs = objOraDb.DbCreateDynaset(strSql,0) ']N1OVw^vf
Response.Write 5 (Lw-_y#
for i=0 to rs.Fields.count-1 'S_OOzpC
Response.Write & rs.fields(i).name & ps DY}y\"
next 8QYP\7}o
Response.Write rjFIK`_w
While Not Rs.Eof jvI!BZ
Response.Write Y
,Iv<Hg
for i=0 to rs.fields.count -1 =N62 ){{
Response.Write & Rs.Fields(i).Value & <6
HrHw_
next y@#JzfY?Hr
Response.Write M+7&kt0;
Rs.MoveNext gQ< >S
Wend @O!BQ^'hk#
Set Rs = Nothing 1BA/$8G
end if ?5N7,|K)
% > =bx;TV
V<:)bG4;d
I%^Bl:M
G^G= .9O
eK=W'cNu
转自: ASP教程采集