Author: Sriram Sanka
-
Solving Sudoku Using SQL – By Anton Scheffer
Here is an Excellent piece of code that Gets the Sudoku Resolved.
-
Date Difference(datediff) Using Oracle SQL – By Thomas Kyte(ASKTOM)
Its an Old Good Script from my Script Collection to find the number of minutes/Seconds/Hours between two dates- Original Author – TomKyte.
-
Install Python Modules using PIP & Upgrading Pip Version
You can Install Python Modules by running Pip command as follows
-
[FATAL] [DBT-06103] The port (5,500) is already in use.
If you get this Port already in use Error While Installing Oracle in Linux., Make sure to have Proper Host Name Configured and Entry in /etc/hosts file.
-
Log4j Zero-Day RCE (CVE-2021-44228) Vulnerability
I came to know about this Critical Vulnerability last night, and below is actual info same as the original content/Post by REDHAT https://access.redhat.com/security/cve/cve-2021-44228, Posting this as it is as I thought Its more clear in their Page on their words. Description A flaw was found in the Java logging library Apache Log4j 2 in versions…
-
MySQL Load Data Statement – Performance
As mentioned in the MySQL Documentation here https://dev.mysql.com/doc/refman/8.0/en/load-data.html , The LOAD DATA statement reads rows from a text file into a table at a very high speed. The file can be read from the server host or the client host, depending on whether the LOCAL modifier is given. LOCAL also affects data interpretation and error handling. Lets Run a Quick Test…
-
Error using MySQL Workbench – unhandled exception list index out of range.
While Loading the data using MySQL Workbench, you may hit the error unhandled exception list index out of range There are no clues in the workbench log files, in such cases you can load the Data Using MySQL LOAD DATA Statement . Which will load the data very fast and without errors. mysql> LOAD DATA…
Sriram Sanka 