DROP SEQUENCE SCHEMA_NAME.USERS_KEY;
CREATE SEQUENCE SCHEMA_NAME.USERS_KEY START WITH 100 MAXVALUE 999999999999999999999999999 MINVALUE 0 NOCYCLE NOCACHE NOORDER;
SELECT KPI_USERS_KEY.NEXTVAL FROM DUAL
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Ciphers\
SELECT * FROM V$LOCK WHERE BLOCK > 0 OR REQUEST > 0 ORDER BY ID1,ID2,BLOCK DESC;2. 把上面的sid帶入 (ex: 1755)
SELECT * FROM V$SESSION WHERE SID IN ( 1755 )3. 找出被lock的table (ex: users)
SELECT * FROM DBA_DML_LOCKS WHERE NAME='USERS'4. 查看是什麼SQL語法造成上面table被lock
SELECT * FROM V$SQL WHERE HASH_VALUE=2803307291
SELECT * FROM DBA_JOBS_RUNNING where job=44807673
begin dbms_job.broken(44807673,true); end;3. 立即砍掉該job
ALTER SYSTEM KILL SESSION '2060,44807673' immediate; --參數'SID, JOB'
Name | Project | Error
108 test Err1, Err2, Err3
109 test2 Err1
輸出結果如下
Name | Project | Error
108 Test Err1
108 Test Err2
108 Test Err3
109 Test2 Err1
with temp as (
select 108 Name, 'test' Project, 'Err1, Err2, Err3' Error from dual
union all
select 109, 'test2', 'Err1' from dual
)
SELECT distinct Name, Project, trim(regexp_substr(str, '[^,]+', 1, level)) str
FROM (SELECT Name, Project, Error str FROM temp) t
CONNECT BY instr(str, ',', 1, level - 1) > 0
order by Name
//新增一個hidden變數, 前後端pass value可透過此變數(常用手法)
<input type="hidden" id="abc" runat='server' />
//新增一個js, 把要傳給後端的參數寫到hidden變數
<script type="text/javascript">
function setvalue() {
var a = document.getElementById("abc");
a.value = "這是js要給後端的參數";
}
</script>
Label1.Text = "承接js傳過來的參數是 "+ Request.Params["abc"];
protected void Page_Load(object sender, EventArgs e) {
form1.InnerHtml = "";
for (int i = 0; i < 10; i++) {
form1.InnerHtml += "<button onclick='send(" + i + ")'>click</button>";
}
}
<script type="text/javascript">
function send(id) {
alert(id);
}
</script>
<script language="javascript"> var emp_id = "<%= catchID %">"; //asp傳值給js ，其實只有這一行 document.form1.method = "post"; document.form1.action = "person.asp?emp_no=" + encodeURIComponent(emp_id); //js把參數傳回給asp，說穿了也只是帶參數傳回而已，就上面那一行而已 //encodeURIComponent是安全考量加的(避免類似XSS攻擊) //如果要回傳多參數, 再用&連接 document.form1.submit(); </script>
<html> <form action="test.asp" method="get"> <input name="tid" type="text" /> <input type="submit" /> </form> </html>test.asp
<html>
<input type="text" name="get_tid" id="get_tid" value="<%= request("tid") %>" />
</html>
120" onMouseOver=alert('XSS_attack') size="1
<script language="javascript">
Object.prototype.isInteger = function () {
return (this.toString().search(/^-?[0-9]+$/) == 0 ) //回傳值為true/false
}
var myNum=1235.6;
alert (myNum.isInteger());
</script>
<html> <form action="test.asp" method="get"> <input name="tid" type="text" /> <input type="submit" /> </form> </html>
<%
response.write encodeURIComponent(request("tid"))
%>
<form action="test.asp" method="post">