Oracle
ZHOUJIAOSHOU
喜欢阅读、爬山
展开
-
sqlplus / as sysdba 详解
在命令窗口输入“sqlplus / as sysdba”后回车,即可连接到Oracle例如C:\>sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on 星期二 4月 17 10:05:34 2012Copyright (c) 1982, 2010, Oracle. All rights reserved.原创 2012-04-17 10:24:55 · 52412 阅读 · 1 评论 -
Vendor initialization failed
使用Delphi7连接Oracle时报错:Vendor initialization failed. Alias:***.项目截图如下: 解决方案:我本机安装是的Oracle9i的客户端1.打开BDE Administrator2.在“Configuration”栏下的“Configuration->Drivers->Native->ORACLE”3.将“D原创 2012-04-20 10:17:21 · 7317 阅读 · 2 评论 -
SQL 重复数据的提取与过滤
SQL 重复数据的提取与过滤 提取重复数据SELECT * FROM tablename GROUP BY colname HAVING COUNT(*) > 1 过滤重复数据SELECT * FROM tablename GROUP BY colname HAVING COUNT(*) = 1原创 2012-08-31 11:15:46 · 9021 阅读 · 0 评论