In MariaDB, we can use the SHOW PROCEDURE STATUS command to return a list of stored procedures.
We can also query the information_schema.routines table to do the same thing.
Author: Ian
3 Ways to Check Column Data Type in Oracle
Here are three ways to get information about a table’s columns in Oracle, including their data types.
Continue reading4 Ways to Check a Column’s Data Type in MySQL
Here are four ways to get the data type of a column in MySQL.
Continue readingReturn Random Rows from a Table in MariaDB
Here’s a quick way to return random rows from a table in MariaDB.
Continue readingMAX() Function in PostgreSQL
In PostgreSQL, the MAX() function computes the maximum of the non-null input values and returns the result.
This function can be used on any numeric, string, date/time, or enum type, as well as inet, interval, money, oid, pg_lsn, tid, and arrays of any of these types.
MIN() Function in PostgreSQL
In PostgreSQL, the MIN() function computes the minimum of the non-null input values and returns the result.
This function can be used on any numeric, string, date/time, or enum type, as well as inet, interval, money, oid, pg_lsn, tid, and arrays of any of these types.
How to Format Numbers with Commas in SQL
Most of the major RDBMSs have functions that enable us to format numbers with commas as either the group separator, or the decimal separator.
Some RDBMSs also output certain numeric data types with commas in the relevant place.
Below are examples of formatting numbers with commas in some of the more popular DBMSs.
Continue readingDATABASE() – Get the Current Database Name in MySQL
In MySQL, DATABASE() is a built-in function that returns the default (current) database name.
The result is returned as a string in the utf8 character set. If there is no default database, it returns NULL.
PRAGMA table_list in SQLite
In SQLite, the table_list pragma returns information about the tables and views in the schema.
It was first introduced in SQLite version 3.37.0 (released on 2021-11-27).
Continue reading3 Ways to Get a List of Databases in SQL Server (T-SQL)
Below are three ways we can use T-SQL to return a list of databases in SQL Server.
Continue reading