数据库
yelb_ianylb
这个作者很懒,什么都没留下…
展开
-
将结果集当作数据表来用
SELECT p.id as id,MAX(p.provider_name) as name,COUNT(r.id_goods) as counts,SUM(r.count_id) as repairCount,SUM(r.sum_repair) as sums [color=green]FROM t_itsm_erp_provider p,t_rs_assetcer...2010-09-26 15:04:34 · 143 阅读 · 0 评论 -
oracle启动的状态
[b]oracle启动的状态[/b]Oracle 数据库服务状态有四个:Shutdown、Nomount、Mount和Open。启动服务可以通过Startup命令进行。[b]oracle实例启动的三个状态。[/b]1 nomount(Instance started)2 mount(Control file opened for this instance)3 open...原创 2011-05-11 14:24:32 · 94 阅读 · 0 评论