About 2007年09月

2007年09月?????sanryuブログ??????????????????????????????????????????

????????2007年08月???

????????2007年10月???

????????????????????????????????????????

Powered by
Movable Type 3.35

« 2007年08月 | ??? | 2007年10月 »

2007年09月 ?????

2007年09月07日

String???Date??

org.apache.commons.lang.time.DateUtils?????.

import java.util.Date;
import org.apache.commons.lang.time.DateUtils;

public class Test1 {

  public static void main(String[] args) {

    /** ???????????? */
    final String[] parsePatterns = {"yyyy/MM/dd", "yyyy/MM/dd HH:mm:ss"};

    try{
      
      Date date = DateUtils.parseDate("2007/09/07", parsePatterns);
      
      System.out.print(date);
      
    }catch ( Exception e ){
      
    }
  }
}

???????

org.apache.commons.lang.time.DateFormatUtils?????.

import java.util.Date;
import org.apache.commons.lang.time.DateFormatUtils;

public class Test2 {
  
  public static void main(String[] args) {


    try{
      
      Date date = new Date();
      
      System.out.println(DateFormatUtils.format(date, "yyyy/MM/dd HH:mm:ss"));
      System.out.println(DateFormatUtils.format(date, "yyyy/MM/dd"));
      System.out.println(DateFormatUtils.format(date, "yyyy/MM"));
      
    }catch ( Exception e ){
      
    }
  }
}

2007年09月13日

10g ???????????

?UNDO????????
??????UNDO????????????

select tablespace_name,retention from dba_tablespaces where tablespace_name = 'UNDOTBS1'

?UNDO?????


alter tablespace 'UNDOTBS1' retention GUARANTEE;

?SCN??????????????


select current_scn,scn_to_timestamp(current_scn) from v$database



select timestamp_to_scn(systimestamp), systimestamp from dual

????????????
SCN??


select name from test as of scn 344387777 where id = 2

??????????????????
SCN??


select
versions_xid XID,
versions_startscn START_SCN,
versions_endscn END_SCN,
versions_operation OPERATION,
id,name
from test versions between scn minvalue and maxvalue

?????????????????????
SCN??


select * from flashbak_transaction_query where table_name='TEST'

?oracle flashbak query


update test set name= (select name from test as of scn 344387777 where id = 2) where id=2

?oracle flushbak table
?flashback table ?? or flashback any table ?? ???

?????????????


alter table test enable row movement

???????????
???????????NG
??????????????NG
?????????????????????


flashback table test to scn 344494686

?oracle flushbak drop

flashback table test to before drop rename to 'test2'

????????????????????????????????NG
??????????????????


--??????
select index_name from user_indexes where table_name='TEST';
--????
alter index "BINXXXXXXXXXXXXX" rename to pk_test;

2007年09月25日

JavaScript?RSS????

jkl-parsexml.js?????JSON???????
????html?????div???innerHTML?????????

???????????????

JAVASCRIPT


<script type="text/javascript" src="jkl-parsexml.js"></script>

<script type="text/javascript">
//<![CDATA[

window.onload = function(){

var url = "atom.xml";
var http = new JKL.ParseXML( url );
var data = http.parse();
var html;

html="<table>";

for (idx in data.feed.entry){

  var entry = data.feed.entry[idx];
  
  var title     = entry.title;
  var href      = entry.link.href;
  var updated   = entry.updated.substring(0,10);
  var table;

  table  = "<tr>";
  table += "<td><a href=\""+href+"\">"+title+"</a></td>";
  table += "<td>("+updated+")</td>";
  table += "</tr>\n";

  html +=table;

}

html+="</table>";

var result=document.getElementById('feedResult');
result.innerHTML = html;

};

//]]>
</script>

BODY?DIV??????


<div id="feedResult"></div>

PHP??????????????

???????URL????????????????

<?php
//POST???? $rss = $_POST['url'];
if( empty($rss)){exit;}
//???? $file = fopen($rss,"r");
if( !$file ) {exit;}
//??? header("Content-type: application/xml; charset=utf-8");
//?? while ( !feof($file)){   $line = fgets($file,1024);   echo $line; }
fclose($file);}
?>

2007年09月26日

Eclipse?Tomcat???????????

Eclipse???????[?????]-[??]-[????]?
?????????????????????????

2007年09月28日

Prototype Window Class?????????????


Prototype Window Class?????
??????????

????

??????????????????????????
????????????????????????????????

??????????????????

2011年03月
Sun Mon Tue Wed Thu Fri Sat
    1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31