0 then !]=[h
Response.Write 错误 : & err.description & p&~8N#I#
response.end ]8FSs/4
End if kaf4GME]
End Sub mlc0XDS%
Sub EndDB() `6;%HbP$W+
Set objOraDB = Nothing 6=A
Set objOraSession = Nothing KR4X&d6
End Sub Lpd q^X
Function getTableList(str) T {Q]
Dim strSql,strTmp q66!xhp;?
Dim objRs E+-ahvk
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 ]`39E"zY
Set objRs = objOraDb.DbCreateDynaset(strSql,0) de{@u<YZb
While Not objRs.Eof 6qg_&woJ3
strA = objRs(uname) & . & objRs(tname) 7qj<|US
AX3iB1):K
If str=strA then v&6I\1
strTmp = strTmp & & strA & QII-9RxX"
Else CUIT)mF:
strTmp = strTmp & & strA & A (z
lX_
End if j"o8]UT/
objRs.MoveNext MQ7d IUs
Wend # rnO=N8
Set objRs = Nothing x[l_dmq
getTableList = strTmp x9S~ns+r
End Function 9>,$q"M}?
% > Zn{,j0;
yneIY-g(p
1_$ybftS
pJ)PVo\cV
06pEA.ro
All Tables : ('k;Ikut
AmYqrmJ
P X/{
lS<T|:gz@
!Ab4'4f
() h# R;'9*V
XIQfgrGZ
\$; Q3t3
\/=w\Tj
^f][;>c
sXe=4`O
then +M@p)pyu
strSql = Select * from & tblname ErZYPl
Set Rs = objOraDb.DbCreateDynaset(strSql,0) rBNl%+ sB
Response.Write P]V/<8o.53
for i=0 to rs.Fields.count-1 ,EhQTVJ
Response.Write & rs.fields(i).name & $TU)O^c
next Z*r;"WHB
Response.Write c j-_
While Not Rs.Eof %A 4F?/E
Response.Write !{On_>`,
for i=0 to rs.fields.count -1 t4HDt\}&k~
Response.Write & Rs.Fields(i).Value & H_3-"m &3
next !a
%6nBo
Response.Write M? 7CBqZ
Rs.MoveNext KBVW<;C$
Wend <hG] f%
Set Rs = Nothing Fh)`A5#
end if a3i;r M2
% > DdAs]e|D[
LHy-y%?i
sqKLz
m5Q?g8
\gtI4zl*J
转自: ASP教程采集