Reading Time: 2 minutesSlicing a string till nth instance of a particular substring in Oracle Slicing a string till nth instance of a particular substring in Oracle How to slice a string up […]
Microsoft Excel: CSV to Excel columns
Reading Time: 1 minutesCSV to Excel columns CSV to Excel columns CSV files i.e Comma Separated Files, open in Microsoft Excel with one or more columns containing a bunch of values separated by a delimiter, […]
Microsoft Excel: Using the CONCATENATE function in Microsoft Excel
Reading Time: 1 minutesUsing the CONCATENATE function in Microsoft Excel Using the CONCATENATE function in Microsoft Excel Today, I had a task of building SQL insert queries from an Excel sheet. The Excel […]
Oracle/SQL: Calculating sizes of different tablespaces in an Oracle database
Reading Time: 1 minutesCalculating sizes of different tablespaces in Oracle Calculating sizes of different tablespaces in Oracle:
Python: Sending a mail with smtplib & email modules
Reading Time: 1 minutesSending mail in Python Sending mail in Python Today, I was working on a script which involved sending a mail with an attachment. I used the following code, which uses […]
Python: Getting today's date
Reading Time: 1 minutesGetting current date in Python Getting current date in Python The date class of Python's builtin datetime module helps us to retrieve current date. You can find the full list […]
Google Chrome: Enabling download resumption
Reading Time: 1 minutesEnabling download resumption in Google Chrome Enabling download resumption in Google Chrome It's fairly common to get 'Network Error' or 'Network Failure' while downloading a large file in Google Chrome. […]
Python: Making a particular version of IDLE as default on clicking 'Edit with IDLE'
Reading Time: 1 minutesMaking a particular version of IDLE as default on clicking 'Edit with IDLE' Making a particular version of IDLE as default on clicking 'Edit with IDLE' If you have two […]
PyPro #3 Python Arithmetic
Reading Time: 1 minutesPython Arithmetic Python Arithmetic The following program demonstrates the arithmetic in Python. Try it online here. See also: Python 101 Object Oriented Python Design Patterns in Python 50+ Handy Standard […]
Vocabulary: Lexicon
Reading Time: 1 minutesLexicon | Vocabulary Lexicon | Vocabulary Hello. Welcome to Lexicon. I created this script when I was learning Perl, as taught by Mr John W Purcell. It brings word of […]