ITPub博客

Const EVENT_SUCCESS=0Const EVENT_ERROR=1Const EVENT_WARNING=2Const EVENT_INFORMATION=4Const EVENT_AUDIT_SUCCESS=8Const EVENT_AUDIT_FAILURE=16Const ForReading = 1 Set objDictionary = CreateObject("Scripting.Dictionary") Set objFSO = CreateObject("Scripting.FileSystemObject") Set objTextFile = objFSO.OpenTextFile _ ("web.txt", ForReading) i = 0 Do Until objTextFile.AtEndOfStream strNextLine = objTextFile.Readline objDictionary.Add i, strNextLine i = i + 1 loop For

strComputer = "." Const EVENT_SUCCESS=0Const EVENT_ERROR=1Const EVENT_WARNING=2Const EVENT_INFORMATION=4Const EVENT_AUDIT_SUCCESS=8Const EVENT_AUDIT_FAILURE=16'On Error Resume NextSet objWMIService = GetObject("winmgmts:" & strComputer & "rootcimv2") Set objShell = CreateObject("Wscript.Shell") Const ForReading = 1 Set objDictionary = CreateObject("Scripting.Dictionary") Set objFSO = CreateObject("Scripting.FileSystemObject") Se

sqlnet.ora 用在oracle client端，用于配置连接服务端oracle的相关参数.tnsnames.ora 用在oracle client端，用户配置连接数据库的别名参数listener.ora 用在oracle server端，配置oracle服务端程序的监听参数一、客户端设置1.sqlnet.ora通过这个文件来决定怎样找一个连接中出现的连接字符串示例文件：# sqlnet.ora Network Configuration File: 安装盘符:oracleproduct10.2.0client_1networkadminsqlnet.ora# Generated by Oracle configuration tools.# This file is actually generated by netca. But if customers choose to # install

SQL> select * from T2; I2---------- 1 2SQL> we discuss the diffrence betwween delete and truncate;SQL> delete from t2;2 rows deleted.SQL> select * from T2;no rows selectedSQL> rollback 2 ;Rollback complete.SQL> select * from T2; I2---------- 1 2SQL> we delete the data from table,we can rollback,and the data deleted will back;SQL> SQL> select * from T2; I2---------- 1 2SQL> truncate table t2;Table