Sunday, October 30, 2011

how to get name of procedure where word like tablename, column name have been used in Oracle

SQL> select distinct name from user_source where upper(type)='PROCEDURE' and upp
er(text) like '%TABLENAME%';

NAME
------------------------------
SP_ABC
SP_BCD
SP_XYZ
SP_LMD
SP_WEEK_ABC
SP_WEEK_XYZ

Friday, October 28, 2011

How to count no of rows in a Textarea in javascript

function rowcount()

var area = document.getElementById("hist");
var text = area.value.replace(/\s+$/g, "");
var split = text.split("\n");
return split.length;
}