Oracle Info - 1 and Self note Script

Coloumn Index  and Coloumn Level
Suppose Coloumn Index  start by 1
Suppose Coloumn Level is NAME,DATE_BIRTH etc

*/ In Oracle Coloumn Level start from 1  and in java Coloumn Level start from 0 .

*/ http://md5decryption.com/

*******************************************************************
Search table name From Tables not too view (From Toad) :
*OPV_PAT%*
*******************************************************************

from java if value go(pass) database 2 rule :
1/   "+admission_no+" (If it is number that means private int admission_no)
2/   '"+admission_no+"' (If it is varchar that means private string admission_no)

*/  Java model class a Private int COUNTRY_ID means only indicate intiger vaue. (Here int is primitive type data type)
*/  Java model class a Private Intiger COUNTRY_ID means it indicates intiger or string value.




*******************************************************************



subject : oracle data type
http://docs.oracle.com/cd/B14117_01/server.101/b10759/sql_elements003.htm

subject : java sms send
http://www.ipipi.com/help/send_text_message_using_java.htm

<script language="javascript">
function getInputVal(td_id,numberId){
//alert(td_id);
alert("kk");
var name = td_id+numberId;
var valOne = document.getElementById(name).innerHTML;

//var valTwo = document.getElementById(numberId).innerHTML;
//var total = parseInt(valOne)+parseInt(valTwo);

alert(valOne);

}
</script>
concatanation : concatanation is add of two string result. So no need double cotation for  string variable of name.

var valOne = document.getElementById(name).innerHTML
Not
var valOne = document.getElementById("sc").innerHTML;

*******************************************************************


Ques: What is sum and concatanation ?
sum : sum is add of two numeric value result.It is need for parseInt

*******************************************************************
<script language="javascript">
function getInputVal(td_id,numberId){
//alert(td_id);
alert("kk");
var sc = td_id+numberId;
var valOne = document.getElementById(sc).innerHTML;
//var valTwo = document.getElementById(numberId).innerHTML;
//var total = parseInt(valOne)+parseInt(valTwo);
alert(valOne);


}
</script>
*******************************************************************

*******************************************************************
Single cotation and double cotation   And no cotation
=====================================================


<td  onClick="getInputVal('record<%=i %>');"><a href="#" ><img src="images/editable.jpg" style="border:none;"/></a>

Direct value pass in function using by single or double cotation.such as-
<script language="javascript">
function getInputVal(td_id){
alert(td_id);

var val = document.getElementById(td_id).innerHTML;
alert(val);

//var val1 = document.getElementById("record1").innerHTML; and var val1 = document.getElementById('record1').innerHTML;  same


alert(val1);


}
</script>



About no cotation
==================
value pass as parameter in function using by no cotation.such as-

<td  onClick="getInputVal('record<%=i %>');"><a href="#" ><img src="images/editable.jpg" style="border:none;"/></a>

Direct value pass in function using by single or double cotation.such as-
<script language="javascript">
function getInputVal(td_id){
alert(td_id);

var val = document.getElementById(td_id).innerHTML;
alert(val);



}
</script>


*********************************************************