sanryuブログ

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

alter tablespace 'UNDOTBS1' retention GUARANTEE;

select current_scn,scn_to_timestamp(current_scn) from v$database

select timestamp_to_scn(systimestamp), systimestamp from dual

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

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

select * from flashbak_transaction_query where table_name='TEST'

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

alter table test enable row movement

flashback table test to scn 344494686

flashback table test to before drop rename to 'test2'

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

<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>

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

<?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);}
?>