Skip to content

Instantly share code, notes, and snippets.

@java-tester-x
java-tester-x / jquery-inline-edit-table-cells.js
Created April 25, 2014 07:25
jquery inline edit table's cells
/**
* jQuery - Edit a table row inline
*
* @link http://stackoverflow.com/a/463587
*
*/
// Iterate over the table cells in the rows, and replace the contents with text inputs:
function editRow(row) {
@java-tester-x
java-tester-x / jQuery-Click-Cell-to-Change-into-Text-Box.js
Created April 25, 2014 07:38
jQuery Click Cell to Change into Text Box.
jQuery Click Cell to Change into Text Box.
@java-tester-x
java-tester-x / AJAX Traditional Polling.js
Created July 25, 2014 05:57
jquery_traditional_polling_2_ways.js
/**
* Traditional Polling
*/
// (1) The setInterval Technique
// Now, if you needed to poll your web service, your first instinct
// might be to do something like this with JavaScript and jQuery:
@java-tester-x
java-tester-x / install_Package_Control_in_Sublime_Text_3.txt
Created December 31, 2014 11:49
install Package Control in Sublime Text 3
import urllib.request,os,hashlib; h = '2deb499853c4371624f5a07e27c334aa' + 'bf8c4e67d14fb0525ba4f89698a6d7e1'; pf = 'Package Control.sublime-package'; ipp = sublime.installed_packages_path(); urllib.request.install_opener( urllib.request.build_opener( urllib.request.ProxyHandler({"http":"http://[proxy_user]:[proxy_password]@[proxy_IP]:[proxy_port]"})) ); by = urllib.request.urlopen( 'http://packagecontrol.io/' + pf.replace(' ', '%20')).read(); dh = hashlib.sha256(by).hexdigest(); print('Error validating download (got %s instead of %s), please try manual install' % (dh, h)) if dh != h else open(os.path.join( ipp, pf), 'wb' ).write(by)
@java-tester-x
java-tester-x / count_rows_in_schemas_tables.sql
Created January 19, 2015 14:47
calculate count of rows in all schemas tables
select table_name
, extractvalue(dbms_xmlgen.getxmltype('select count(1) cnt FROM '||table_name), '/ROWSET/ROW/CNT') num_rows
from user_tables
order by table_name;
@java-tester-x
java-tester-x / gen_hierarchical_rowset_from_file_paths.sql
Created February 12, 2016 11:47
hierarchical rowset from file paths
with f as (
select '$Root\File1.ext' file_name from dual union all
select '$Root\Folder1\File1.ext' file_name from dual union all
select '$Root\Folder1\File2.ext' file_name from dual union all
select '$Root\Folder1\Folder2\File1.ext' file_name from dual union all
select '$Root\Folder1\Folder2\File2.ext' file_name from dual union all
select '$Root\Folder1\Folder2\File3.ext' file_name from dual union all
select null from dual where 1=0
)
, p as (