0 then `Z^\<{z
Response.Write 错误 : & err.description & o1R:1!"2
response.end :!yPR
End if ~s*kuj'%+
End Sub &}r-C97
Sub EndDB() ,!dVhG#
Set objOraDB = Nothing 3b[.s9Q
Set objOraSession = Nothing |[!7^tU*
End Sub MU:q`DRr
Function getTableList(str) !v.
<H]s)
Dim strSql,strTmp lYT_Y.%I
Dim objRs MY'T%_id
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 B ?l0u
Set objRs = objOraDb.DbCreateDynaset(strSql,0) I%l2_hs0V
While Not objRs.Eof x>tsI}C
strA = objRs(uname) & . & objRs(tname) @%jY
YI>9C 76L
If str=strA then e$7KMH=
strTmp = strTmp & & strA & f4Ob4ah!(
Else %UlgG1?A
strTmp = strTmp & & strA & 35JVF*z
End if A1n4R
objRs.MoveNext _+,>NJ
Wend i0F6eqe=J
Set objRs = Nothing Qs ysy
getTableList = strTmp &v#pS!UO j
End Function f2u4*X
E\
% > g@Pq<
Y`."=8R~
,P%i%YPj
hP}-yW6]
5zOC zm
All Tables : 3_8W5J3I
Qb|@DMq%
.bUj
Mm;[f'{M)
3&6sQ-}*
() "}vxHN#
_2hZGC%&E
@z^7*#vQv
~G1B}c]
KL./
|K" nSXzk
then DMOP*;Uk
strSql = Select * from & tblname UF$O@l
Set Rs = objOraDb.DbCreateDynaset(strSql,0) "7eL&
Response.Write g7{:F\S
for i=0 to rs.Fields.count-1 dQ_hlx!J
Response.Write & rs.fields(i).name & (|>rDk;
next izzX$O[=:
Response.Write Tgl >
While Not Rs.Eof PS8^=
Response.Write V|~o`(]
for i=0 to rs.fields.count -1 U>sEFzBup
Response.Write & Rs.Fields(i).Value & eD8e0
D'S
next |{JI=$
Response.Write |w+
O.%=
Rs.MoveNext rZWs-]s6t
Wend Ckc5;:b&m
Set Rs = Nothing )2Bb,p<Wr
end if H>o \C
% > %|j8#09
A/{!w"G
\AIFIy
/P Tq.
vqZBDQ0
转自: ASP教程采集