Skip to content Skip to sidebar Skip to footer
Showing posts with the label Shell

Sed - Replace Multiline String Between Patterns In Different Lines

I have few .sql files that contain comments marked as '/* */' Comment can start and end at … Read more Sed - Replace Multiline String Between Patterns In Different Lines

How To Check If Columns Are Being Used By Views?

I have an excel sheet with list of columns mentioned in it. I would now like to know what all colum… Read more How To Check If Columns Are Being Used By Views?

Create Database Using Psql In Shell Script Takes Username As Db Name

Following is the command I am using to create database in shell script psql -v ON_ERROR_STOP=1 --us… Read more Create Database Using Psql In Shell Script Takes Username As Db Name

Shell Scripting Sqlite

How do I write a shell script that displays SQLite results? I have written a script that adds an en… Read more Shell Scripting Sqlite

How Can I Escape Characters In Sqlite Via Bash Shell?

I am trying to send a query to SQLite from the command line using bash. I need to escape both singl… Read more How Can I Escape Characters In Sqlite Via Bash Shell?

Set Different Oracle_home And Path Environment Variable Using Ansible

Im currently querying multiple databases and capturing the results of the query The way Im doing i… Read more Set Different Oracle_home And Path Environment Variable Using Ansible