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, […]
Month: January 2016
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 […]