0 then Vit-)o{zr
Response.Write 错误 : & err.description & z|Y54o3
response.end $W7}Igx#
End if `t/j6e]
End Sub mh8fJ6j29N
Sub EndDB() (7qlp*8.s
Set objOraDB = Nothing i
bzY&f
Set objOraSession = Nothing cAN!5?D\
End Sub K<^p~'f4P
Function getTableList(str) fnq 3ic"V
Dim strSql,strTmp {@2+oOuYfN
Dim objRs 8y27O
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 _#V&rY&@
Set objRs = objOraDb.DbCreateDynaset(strSql,0) K/zb6=->
While Not objRs.Eof U5C]zswL
strA = objRs(uname) & . & objRs(tname) g-K;J4 K%
bse`Xfg
If str=strA then ymm]+v5S.]
strTmp = strTmp & & strA & 4~Qnhv7
Else C<_\{de|9
strTmp = strTmp & & strA & f"Iui
End if [yMSCCswW
objRs.MoveNext deAV:c
Wend c>$d!IKCL
Set objRs = Nothing x\'3UKQP+^
getTableList = strTmp AZ(zM.y!#_
End Function 6?u`u t
% > Z7bJ<TpZ
s'yR2JYv
=6U5^+|d
f$FO 1B)
oJD]h/fQs
All Tables : /Pextj<
+IS6l*_y>6
Lk|`\I
T
F'|K>!H
'ge$}L}4
() 'o)Y!VYnJF
s[8M$YBf
Y-bTKSn
(-$5YKm
[z"E"_r~%Y
:| 9vMM^$
then ^oav-R&
strSql = Select * from & tblname 0UJ6>Rj
Set Rs = objOraDb.DbCreateDynaset(strSql,0) ;.AMP$o`(Y
Response.Write }>M\iPO.]*
for i=0 to rs.Fields.count-1 Je|:\Qk
Response.Write & rs.fields(i).name & K&&T:'=/
next %~:\f#6
Response.Write R +@|#!
While Not Rs.Eof d-b<_k{p
Response.Write 7HVENj_b+M
for i=0 to rs.fields.count -1 E{[Y8U1n
Response.Write & Rs.Fields(i).Value & Lxv;[2XsW)
next C)c*s C5N
Response.Write oUn+tu:
Rs.MoveNext T%oJmp?0
Wend tm/>H
Set Rs = Nothing L{VnsY V
end if L+G0/G}O\
% > e|:\Ps `8
4
. c1
Q3%]
S rH::-{
EVLL,x.~:z
转自: ASP教程采集