Santosh 的个人资料Santosh Kumar照片日志列表更多  |  工具 帮助 |
Javascript, Printing a selected block<HTML> <HEAD> <SCRIPT LANGUAGE="JavaScript"> <!-- function fPrint(oEle){ w=window.open('about:blank'); w.document.body.innerHTML=oEle.innerHTML; w.document.body.style.font="9pt courier new"; w.document.body.style.leftMargin=0; w.document.body.style.rightMargin=0; w.print(); w.close(); } //--> </SCRIPT> </HEAD> <BODY leftmargin=0> This text will not appear while printing the following table <div id = t style="font-family:'courier new';font-size:9pt;"> <TABLE > <TR><TD>11</TD><TD>12</TD><TD>13</TD><TD>14</TD></TR> <TR><TD>22</TD><TD>22</TD><TD>23</TD><TD>24</TD></TR> <TR><TD>33</TD><TD>32</TD><TD>33</TD><TD>34</TD></TR> <TR><TD>44</TD><TD>42</TD><TD>43</TD><TD>44</TD></TR> <TR><TD>55</TD><TD>52</TD><TD>53</TD><TD>54</TD></TR> <TR><TD>66</TD><TD>62</TD><TD>63</TD><TD>64</TD></TR> </TABLE> </div> This line and the button below will also be ignored while printing<br> <input type=button value='Print Table' onClick="fPrint(t)"> </BODY> </HTML> »»»»»»» by Santosh Kumar ? Original @ http://santu4you.spaces.live.com Oracle, Getting date differencescreate or replace function period_diff (fdt date, tdt date) return varchar as bdt date; y number; m number; d number; begin y:=0; m:=0; d:=0; if fdt > tdt then bdt := tdt; else bdt := fdt; end if; loop exit when to_char(add_months(bdt,12),'yyyymmdd') > to_char(tdt,'yyyymmdd'); y := y + 1; bdt := add_months(bdt,12); end loop; loop exit when to_char(add_months(bdt,1),'yyyymmdd') > to_char(tdt,'yyyymmdd'); m := m + 1; bdt := add_months(bdt,1); end loop; loop exit when to_char(bdt + 1,'yyyymmdd') > to_char(tdt,'yyyymmdd'); d := d + 1; bdt := bdt +1; end loop; return y || 'y, ' || m || 'm, ' || d || 'd'; end; / Function created. SQL> select hiredate, period_diff(hiredate,'13-Nov-2007') exp from emp HIREDATE EXP --------- ----------------- 17-DEC-80 26y, 10m, 27d 20-FEB-81 26y, 8m, 24d 22-FEB-81 26y, 8m, 22d 02-APR-81 26y, 7m, 11d 28-SEP-81 26y, 1m, 16d 01-MAY-81 26y, 6m, 12d 09-JUN-81 26y, 5m, 4d 09-DEC-82 24y, 11m, 4d 17-NOV-81 25y, 11m, 27d 08-SEP-81 26y, 2m, 5d 12-JAN-83 24y, 10m, 1d 03-DEC-81 25y, 11m, 10d 03-DEC-81 25y, 11m, 10d 23-JAN-82 25y, 9m, 21d 14 rows selected. SQL> »»»»»»» by Santosh Kumar ? Original @ http://santu4you.spaces.live.com |
|
|
