In this tutorial we will be setting up Oracle on the Ubuntu system. For the tutorial purpose I will be using the Oracle XE 19.3.0 version. The same tutorial should work for any other oracle version as well. Pre-requisite - Ubuntu 18.04 +, Git 1. Set up docker on Ubuntu following below instructions. https://docs.docker.com/engine/install/ubuntu/ 2. … Continue reading Setup Oracle in Ubuntu 20.04
If you'd need to create a folder for current date in format as YYMMDDHH using python - You can use below code. This will create folder with "00" in hour if the time is between 00:00 to 12:00PM and from 12PM till 00:00AM, it will created folder with "12". For 2022-06-26 09:00:00 - It will … Continue reading Create a folder in Python of Current date format
Use below command to get only table data from a PostgreSQL table. It will not dump table create structure.
You can use the below query to get number of rows per partition in a MySQL table.
GIPSA (General Insurance Public Sector Association) is a group of four public sector insurance companies. These insurance companies are - New India Assurance CompanyNational Insurance CompanyUnited India Insurance CompanyOriental Insurance Company It has created a standard pricing for major & frequent medical treatments. It has restricted their cashless claims service to hospitals which follows their … Continue reading What is GIPSA ?
You can use MySQL's inbuilt function TIMESTAMPDIFF to get difference between two dates in MySQL. A typical query would be
Python's official Documentation says below thing about CSV files, The so-called CSV (Comma Separated Values) format is the most common import and export format for spreadsheets and databases. CSV format was used for many years prior to attempts to describe the format in a standardized way in RFC 4180. Reading & Writing CSV files is very … Continue reading Reading CSV file in python
Lets say i have a collection named testsize, using below command will give me > db.testsize.totalSize() 200 total size in bytes of the data in the collection plus the size of every indexes on the collection. For more information read official mongodb doc here.
Use below command to install a RPM package on Fedora / CentOS.
Wow, Python startup time is worse than I thought. Here’s some data from a fast Ubuntu box. I ran all commands a bunch of times to warm caches.
That last one’s a bit of a winner; -S means “don’t load site modules” and comes from this ExpertsExchange discussion. I lose /usr/local/lib; if I manually add that in my script I get my minimal libgit2 program down to 6ms.