select SUBSTR(mail, 0,INSTR(mail,'@')-1)
from dual;
例如:
邮箱:wxtx@hotmail.com
select SUBSTR('wxtx@hotmail.com', 0,INSTR('wxtx@hotmail.com','@')-1)
from dual;
输出:wxtx
|
<script>
var _table=document.getElementById("table1");
cleanWhitespace(_table);
function cleanWhitespace(element) {
//遍历element的子结点
if(element!=null){
for (var i = 0; i < element.childNodes.length; i++) {
var node = element.childNodes[i];
//判断是否是空白文本结点,如果是,则删除该结点
if (node.nodeType == 3 && !/S/.test(node.nodeValue))
node.parentNode.removeChild(node);
}
}
}
// 上移
function moveUp(_a,row){
var _row=_a.parentNode.parentNode.parentNode.parentNode;
//如果不是第一行,则与上一行交换顺序
if(_row.previousSibling){
swapNode(_row,_row.previousSibling);
}
var rowvalue = document.getElementById("approval_orderby"+row).value;
var newRow = rowvalue -1;
if(eval(newRow)-1 < 0){
alert("不能上移!");
}else{
document.getElementsByName("approval_orderby")[newRow-1].value = eval(rowvalue) -1;
document.getElementsByName("approval_orderby")[newRow].value = eval(rowvalue) ;
}
}
// 下移
function moveDown(_a,row){
var empnoParent = document.getElementsByName("approval_orderby");
var _row=_a.parentNode.parentNode.parentNode.parentNode;
//如果不是最后一行,则与下一行交换顺序
if(_row.nextSibling){
swapNode(_row,_row.nextSibling);
}
var rowvalue = document.getElementById("approval_orderby"+row).value;
var newRow = rowvalue -1;
if(eval(newRow)+1 >= empnoParent.length){
alert("不能下移!");
}else{
document.getElementsByName("approval_orderby")[newRow].value = eval(rowvalue) ;
document.getElementsByName("approval_orderby")[newRow + 1].value = eval(rowvalue) + 1;
}
}
// 交换节点
function swapNode(node1,node2){
// 获取父结点
var _parent=node1.parentNode;
//获取两个结点的相对位置
var _t1=node1.nextSibling;
var _t2=node2.nextSibling;
//将node2插入到原来node1的位置
if(_t1){
_parent.insertBefore(node2,_t1);
}else{
_parent.appendChild(node2);
}
//将node1插入到原来node2的位置
if(_t2){
_parent.insertBefore(node1,_t2);
}else{
_parent.appendChild(node1);
}
}
</script>
<table cellspacing="0" class="board_list" id="table1">
<#list atLinelist?if_exists as current>
<tr>
<td>
<div>
<li style="float:left; padding-left:5px;"><img src="/equi/images/up.gif" onclick="moveUp(this,'${current_index+1}')"></li>
<li style="float:left; padding-left:5px;"><img src="/equi/images/down.gif" onclick="moveDown(this,'${current_index+1}')"></li>
<input type="hidden" name="approval_orderby" id="approval_orderby${current_index+1}" value="${current_index+1}">
</div>
</td>
</tr>
</#list>
</table>
|