Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\database\instance\sql\worksheet.js

function getSelectionInfoInSQLTextArea()
{  
	var txtarea = document.getElementById("text_area");
  txtarea.focus();
  
	if (txtarea.selectionStart >= 0)
	{ // Mozilla
        document.forms[0].browserType.value = 'Mozilla';
	var selStart = txtarea.selectionStart;
	var selEnd = txtarea.selectionEnd;
  if (selStart != selEnd)
  {
      while(isNewLine(txtarea.value.charAt(selStart)))
          selStart++; 
      while((selEnd-1 >= 0) && isNewLine(txtarea.value.charAt(selEnd-1)))
          selEnd--;
    document.forms[0].selectedSQLText.value = (txtarea.value).substring(selStart, selEnd);        
    document.forms[0].selectionStart.value = selStart;
    document.forms[0].selectionEnd.value = selEnd;
  }
  else
  { 
    document.forms[0].selectedSQLText.value = getSelectedSQLText(txtarea.value, selStart);    
    if (isNewLine(txtarea.value.charAt(document.forms[0].selectionEnd.value-1)))
        document.forms[0].selectionEnd.value--;
  }

document.forms[0].textBeforeSelectedSQLText.value = (txtarea.value).substring(0, document.forms[0].selectionStart.value);
  document.forms[0].textAfterSelectedSQLText.value = (txtarea.value).substring( document.forms[0].selectionEnd.value, txtarea.value.length);

document.forms[0].scrollPos.value = txtarea.scrollTop;  
  
  return;
	}

if( document.selection  || document.getSelection())
  { // IE
        document.forms[0].browserType.value = 'IE';
  if (document.selection)
    range = document.selection.createRange();
  else
    range = document.getSelection().createRange();
	var stored_range = range.duplicate();
	stored_range.moveToElementText( txtarea );
	stored_range.setEndPoint( 'EndToEnd', range );
  var selStart = stored_range.text.length - range.text.length;
	var selEnd = selStart + range.text.length;
  if (selStart != selEnd)
  {
      while(isNewLine(txtarea.value.charAt(selStart)))
          selStart++; 
      while((selEnd-1 >= 0) && isNewLine(txtarea.value.charAt(selEnd-1)))
          selEnd--;
    document.forms[0].selectedSQLText.value = (txtarea.value).substring(selStart, selEnd);
    document.forms[0].selectionStart.value = selStart;
    if (isNewLine(txtarea.value.charAt(selEnd-1)))
        document.forms[0].selectionEnd.value = selEnd; 
    else
        document.forms[0].selectionEnd.value = selEnd+1;
  }
  else
  {
    document.forms[0].selectedSQLText.value = getSelectedSQLText(txtarea.value, selStart);
    if (isNewLine(txtarea.value.charAt(document.forms[0].selectionEnd.value-1)))
        document.forms[0].selectionEnd.value--;
    else
        document.forms[0].selectionEnd.value++;
  }

document.forms[0].textBeforeSelectedSQLText.value = (txtarea.value).substring(0, document.forms[0].selectionStart.value);
  document.forms[0].textAfterSelectedSQLText.value = (txtarea.value).substring((document.forms[0].selectionEnd).value-1, (txtarea.value).length);

document.forms[0].fullTextLength.value = (txtarea.value).length;
  document.forms[0].scrollPos.value = txtarea.scrollTop;  
  
  return;
	}

return;
}

function isWhite(c)
{
    return ((c == '\t') || (c == ' ') || (c == '\n') || (c == '\r'));    
}

function isNewLine(c)
{
    return ((c == '\n') || (c == '\r'));    
}

function trim(s) 
{
    var i, j = s.length;

for (i = 0; isWhite(s.charAt(i)) && (i < j); i++)
        ;
    if (i == j) 
    {
      return ""; //whole string is white
    }
    for (; isWhite(s.charAt(j-1)); j--)
        ;
    return s.substring(i, j);
}

function getSelectedSQLText(str, ind)
{    
  var index = ind;

while (isWhite(str.charAt(index)) && (index-1) >= 0)
  {
    if (str.charAt(index-1) == '\n' || str.charAt(index-1) == '\r')
    {
      break;
    }    
    index--;
  }  
  
  if (trim(str.substring(0, index)).length == 0)
    index = ind;
  while (isWhite(str.charAt(index)) && (index+1) < str.length)
  {
    index++;
  }

var sql = str.substring(sqlStart, sqlEnd+1);

var i, j = sql.length;
  for (i = 0; isWhite(sql.charAt(i)) && (i < j); i++)
  {
      sqlStart++; 
  }

if (i == j) 
  {
      sql = ""; //whole string is white
  } 
  
  for (; isWhite(sql.charAt(j-1)); j--)
  {
      sqlEnd--;
  }

document.forms[0].selectionStart.value = sqlStart;
  document.forms[0].selectionEnd.value = sqlEnd+1;

return sql;
}

setTimeout('document.getElementById("processIcon").src = "/em/images/process_animation.gif"', 20); 
}

function submitFormAndSwitchTab(pageNum)
{
  getSelectionInfoInSQLTextArea();
  document.forms[0].event.value = 'switchTab';
  document.forms[0].toPageNum.value = pageNum;
  document.forms[0].submit();
}

oRange.select();   
    txtarea.scrollTop = scrollPos;
  }      
}

function calculateStart(str, selectionStart)
{
  var temp = selectionStart;
  for (var i = 0; i < selectionStart; i++)
  {
    if (str.charAt(i) == '\n' && str.charAt(i-1) == '\r')
      temp--;
    if (i > str.length)
      break;
  }
  return temp;
}

function calculateEnd(str, selectionEnd)
{
  var temp = selectionEnd;  
  
  for (var i = str.length-1; i >= selectionEnd; i--)
  {
    if (str.charAt(i) == '\n' && str.charAt(i-1) == '\r')
      temp++;
    if (i < 0)
      break;
  }

return temp;
}

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de