数据库
database
MissYourKiss
天若云舒展,淡然致雅意,清风月弄影,闲适乱翻书
展开
-
connect to db2 with db2 client
<br />First: <br />Install db2 client<br /> <br />Two:<br />use start->IBM DB2->Command Line Tool->Command window <br />C:/Program Files/IBM/SQLLIB/BIN>db2ilist<br />C:/Program Files/IBM/SQLLIB/BIN>set DB2INSTANCE=DB2<br />C:/Program Files/IBM/SQLLIB/BIN>d原创 2010-07-05 20:48:00 · 565 阅读 · 0 评论 -
oracle database link
<br />Example First:<br />--remote server 138.138.1.61 user:user61 password:pwd61<br />--local tnsnames.ora has a connection sev61<br />create database link db61 connect to user61 indentified by pwd61 using 'sev61';<br /> <br />select * from rmt_tb@db61;<b原创 2010-07-09 15:49:00 · 681 阅读 · 0 评论 -
the art of sql(一)
<br /> Query Identification<br /> Stable Database Connections<br /> Strategy Before Tactics(Thinking Outside the Box)<br /> Problem Definition Before Solution<br /> OperationsAgainst Actual Data<br /> Set Processing in SQL<br /> Action-Packed SQL Sta原创 2010-08-06 18:33:00 · 449 阅读 · 0 评论 -
oracle-usefull sql(一)
1.完全备份的SH文件:exp_comp.shrq=` date +"%m%d" `su - oracle -c "exp system/manager full=y inctype=complete file=/oracle/export/db_comp$rq.dmp"累计备份的SH文件:exp_cumu.shrq=` date +"%m%d" `su - oracle -c原创 2010-08-06 18:35:00 · 579 阅读 · 0 评论