-
编辑 删除
sqlnet.ora tnsname.ora listener.ora 的作用
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
-
编辑 删除
Diffrence Between delete and truncate
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
