Mon, 25 Aug 2008 10:13:00 GMThttp://blog.csdn.net/liying1985/http://blog.csdn.net/liying1985/archive/2008/08/25/2825721.aspxhttp://blog.csdn.net/liying1985/comments/2825721.aspx0http://blog.csdn.net/liying1985/comments/commentRss/2825721.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2825721<P><STRONG>Step 1: </STRONG>Stop the Oracle service on the new server to make sure everything smooth. On Windows 2003 server, just go into the Service console of Administrative tools, and click Stop button for Oracle service.</P> <P><BR><STRONG>Step 2: </STRONG>Make sure the oracle service on both machines are similar. Like the existing one called MYDATA then the new one should be better called MYDATA too. If not, then create an Oralce service with the same name on the new server. I am not sure<img src ="http://blog.csdn.net/liying1985/aggbug/2825721.aspx" width = "1" height = "1" />Mon, 25 Aug 2008 18:13:00 +0800liyinghttp://blog.csdn.net/liying1985/archive/2008/08/25/2825721.aspx#Feedbackhttp://blog.csdn.net/liying1985/archive/2008/08/25/2825721.aspxliyinghttp://blog.csdn.net/liying1985/archive/2008/08/25/2825721.aspxhttp://blog.csdn.net/liying1985/feed.aspxcsdn.net/liying1985/~7406222/212162769/5515743http://blog.csdn.net/liying1985/archive/2008/08/25/2825670.aspxhttp://blog.csdn.net/liying1985/comments/2825670.aspx0http://blog.csdn.net/liying1985/comments/commentRss/2825670.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2825670<STRONG>Challenge:<BR></STRONG>Let me assume this: we have two tables, one is Regions table with all region information (East, West, etc. ) and we have another table with Sales information. Now, we need to display a report with region information and how many sales conducted in each region with greater than $1000 value in each sale. It sounds simple at the beginning since a <STRONG>Count(*)</STRONG> with <STRONG>Group By</STRONG> can do this trick. <P>But what if I need to still show the regio<img src ="http://blog.csdn.net/liying1985/aggbug/2825670.aspx" width = "1" height = "1" />Mon, 25 Aug 2008 18:07:00 +0800liyinghttp://blog.csdn.net/liying1985/archive/2008/08/25/2825670.aspx#Feedbackhttp://blog.csdn.net/liying1985/archive/2008/08/25/2825670.aspxliyinghttp://blog.csdn.net/liying1985/archive/2008/08/25/2825670.aspxhttp://blog.csdn.net/liying1985/feed.aspxcsdn.net/liying1985/~7406222/212162770/5515743http://blog.csdn.net/liying1985/archive/2008/08/07/2781770.aspxhttp://blog.csdn.net/liying1985/comments/2781770.aspx1http://blog.csdn.net/liying1985/comments/commentRss/2781770.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2781770&lt;P&gt;&lt;IMG height=400 alt="" src="http://p.blog.csdn.net/images/p_blog_csdn_net/liying1985/441211/o_renao.JPG" width=500&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;我在热闹的人群，心在远远的离开&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;青岩，绿林，白雾，碧水......&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;素雅的画中......&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;藏着无边的空寂之感....&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;在热闹的人群中,游离在寂寞的山水画中,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;心在远远的离开<img src ="http://blog.csdn.net/liying1985/aggbug/2781770.aspx" width = "1" height = "1" />Thu, 07 Aug 2008 21:03:00 +0800liyinghttp://blog.csdn.net/liying1985/archive/2008/08/07/2781770.aspx#Feedbackhttp://blog.csdn.net/liying1985/archive/2008/08/07/2781770.aspxliyinghttp://blog.csdn.net/liying1985/archive/2008/08/07/2781770.aspxhttp://blog.csdn.net/liying1985/feed.aspxcsdn.net/liying1985/~7406222/212162771/5515743http://blog.csdn.net/liying1985/archive/2008/07/13/2646053.aspxhttp://blog.csdn.net/liying1985/comments/2646053.aspx1http://blog.csdn.net/liying1985/comments/commentRss/2646053.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2646053失踪~~~<img src ="http://blog.csdn.net/liying1985/aggbug/2646053.aspx" width = "1" height = "1" />Mon, 14 Jul 2008 02:03:00 +0800liyinghttp://blog.csdn.net/liying1985/archive/2008/07/13/2646053.aspx#Feedbackhttp://blog.csdn.net/liying1985/archive/2008/07/13/2646053.aspxliyinghttp://blog.csdn.net/liying1985/archive/2008/07/13/2646053.aspxhttp://blog.csdn.net/liying1985/feed.aspxcsdn.net/liying1985/~7406222/212162772/5515743http://blog.csdn.net/liying1985/archive/2008/07/13/2646045.aspxhttp://blog.csdn.net/liying1985/comments/2646045.aspx1http://blog.csdn.net/liying1985/comments/commentRss/2646045.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2646045只是写下来怀念 ~~<img src ="http://blog.csdn.net/liying1985/aggbug/2646045.aspx" width = "1" height = "1" />Mon, 14 Jul 2008 01:55:00 +0800liyinghttp://blog.csdn.net/liying1985/archive/2008/07/13/2646045.aspx#Feedbackhttp://blog.csdn.net/liying1985/archive/2008/07/13/2646045.aspxliyinghttp://blog.csdn.net/liying1985/archive/2008/07/13/2646045.aspxhttp://blog.csdn.net/liying1985/feed.aspxcsdn.net/liying1985/~7406222/212162773/5515743http://blog.csdn.net/liying1985/archive/2008/06/26/2587910.aspxhttp://blog.csdn.net/liying1985/comments/2587910.aspx7http://blog.csdn.net/liying1985/comments/commentRss/2587910.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2587910The Story of today.<img src ="http://blog.csdn.net/liying1985/aggbug/2587910.aspx" width = "1" height = "1" />Thu, 26 Jun 2008 19:01:00 +0800liyinghttp://blog.csdn.net/liying1985/archive/2008/06/26/2587910.aspx#Feedbackhttp://blog.csdn.net/liying1985/archive/2008/06/26/2587910.aspxliyinghttp://blog.csdn.net/liying1985/archive/2008/06/26/2587910.aspxhttp://blog.csdn.net/liying1985/feed.aspxcsdn.net/liying1985/~7406222/212162774/5515743http://blog.csdn.net/liying1985/archive/2008/06/23/2578777.aspxhttp://blog.csdn.net/liying1985/comments/2578777.aspx4http://blog.csdn.net/liying1985/comments/commentRss/2578777.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2578777赫赫 终于解脱了....<img src ="http://blog.csdn.net/liying1985/aggbug/2578777.aspx" width = "1" height = "1" />Mon, 23 Jun 2008 22:44:00 +0800liying1985http://blog.csdn.net/liying1985/archive/2008/06/23/2578777.aspx#Feedbackhttp://blog.csdn.net/liying1985/archive/2008/06/23/2578777.aspxliying1985http://blog.csdn.net/liying1985/archive/2008/06/23/2578777.aspxhttp://blog.csdn.net/liying1985/feed.aspxcsdn.net/liying1985/~7406222/212162775/5515743http://blog.csdn.net/liying1985/archive/2008/06/04/2511817.aspxhttp://blog.csdn.net/liying1985/comments/2511817.aspx4http://blog.csdn.net/liying1985/comments/commentRss/2511817.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=25118172个人只能平行的走着走着.... <img src ="http://blog.csdn.net/liying1985/aggbug/2511817.aspx" width = "1" height = "1" />Thu, 05 Jun 2008 02:00:00 +0800liying1985http://blog.csdn.net/liying1985/archive/2008/06/04/2511817.aspx#Feedbackhttp://blog.csdn.net/liying1985/archive/2008/06/04/2511817.aspxliying1985http://blog.csdn.net/liying1985/archive/2008/06/04/2511817.aspxhttp://blog.csdn.net/liying1985/feed.aspxcsdn.net/liying1985/~7406222/212162776/5515743http://blog.csdn.net/liying1985/archive/2008/06/02/2503026.aspxhttp://blog.csdn.net/liying1985/comments/2503026.aspx4http://blog.csdn.net/liying1985/comments/commentRss/2503026.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2503026一些些的伤感<img src ="http://blog.csdn.net/liying1985/aggbug/2503026.aspx" width = "1" height = "1" />Mon, 02 Jun 2008 21:13:00 +0800liying1985http://blog.csdn.net/liying1985/archive/2008/06/02/2503026.aspx#Feedbackhttp://blog.csdn.net/liying1985/archive/2008/06/02/2503026.aspxliying1985http://blog.csdn.net/liying1985/archive/2008/06/02/2503026.aspxhttp://blog.csdn.net/liying1985/feed.aspxcsdn.net/liying1985/~7406222/212162777/5515743