Sapna ChatraniOracle -Advanced conceptsIn this blog I will try to explain some advance concepts which come handy in your daily tasks.Jul 31, 20222Jul 31, 20222
Sapna ChatraniSQL & PL/SQL conceptsIn this blog, I will demonstrate few sql/plsql concepts along with examples which could be helpful to prepare for interview.Jul 30, 20221Jul 30, 20221
Sapna ChatraniPostgreSQL — steps to migrate postgres from default directory to specific directoryOften when we install postgresql, it is installed in root directory i.e “var/lib/pgsql/data” and subsequently all the data files are…Jul 28, 20223Jul 28, 20223
Sapna ChatraniPostreSQL — How to read data from JSON fieldIn this blog, I will try to explain (with Example) the steps to read data from a JSON field in PostgreSQL. JSON is a datatype that stores…Jul 27, 20222Jul 27, 20222
Sapna ChatraniSteps to create JIRA Scrum board and SprintThis blog is about to show steps used to create JIRA scrum board & Sprint from scratch with screenshots.Jul 26, 20221Jul 26, 20221
Sapna ChatraniData Dictionary Views -Oracle v/s Azure SQLIn this blog I am going to share some basic sql scripts to query data dictionary views in oracle and sql. These scripts will be helpful to…Jul 25, 20222Jul 25, 20222
Sapna ChatraniPostgreSQL BasicsThis Blog is about creating schema, roles, tablespace and tables in postgreSQL Database.Jul 22, 2022Jul 22, 2022
Sapna ChatraniPostgreSQL Installation on Unix/Linux platformThis blog is about PostgreSQL installation on Linux platform.Jul 22, 2022Jul 22, 2022
Sapna ChatraniOracle VS Azure SQL (Date Functions)In this Blog I will be explaining how to use date functions Oracle and AzureSQLJul 21, 20222Jul 21, 20222
Sapna ChatraniOracle VS Azure SQL (String Functions)In this Blog I will explaining Azure sql functions for corresponding Oracle inbuilt functions.Jul 21, 20221Jul 21, 20221