This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 ( |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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) |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/** | |
* 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: |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
jQuery Click Cell to Change into Text Box. |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/** | |
* 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) { |