How to display SQLite results as one column per line

SQLite is a relational database management system contained in a C library. In contrast to many other database management systems, SQLite is not a client–server database engine. Rather, it is embedded into the end program.

Usually the results from SQLite database displays all together in a line which will be difficult to analyse if the data is huge.

We can use "-line" option on SQLite database to display results as one column per line.

sqlite3 -line database.db