DJ메탈짱™의 Free Style

1. DataBase SizeSELECT SUM(bytes)/1024/1024 FROM dba_data_files; 2. Table Size SELECT SUM(bytes)/1024/1024 FROM dba_extents WHERE segment_name='CORP_NEWS_TB'; 3.=================================================================The biggest portion of a database"s size comes FROM the datafiles. To find out how many megabytes are allocated to ALL datafiles: --> SELECT SUM(bytes)/1024/1024 "Meg" FROM..

// 2011/07/13 - LINQ query (SUM)var tSum =from p in db.TBSimulation // from절ywhere p.USERID == this.hdUSERID.Text && p.GROUPID == "A" // where절yselect p.RESULT; // select절y // Total Profit this.lblTPROFIT.Text = tSum.Sum().ToString();

// LINQ query (SUM) var tSum = from p in db.TBSimulation // from절 where p.USERID == "" // where절 group p by new { p.GROUPID,p.USERID } into grouping // group by select new // sum column { grouping.Key, Totalprice = grouping.Sum(p => p.RESULT) }; // sum값 바인딩 foreach (var grp in tSum) { this.lblTPROFIT.Text = grp.Totalprice.ToString(); }