Here are three examples of returning a list of stored procedures that reference a specific table in PostgreSQL.
how to
3 Ways to List all Triggers for a Given Table in PostgreSQL
Here are three options for listing out the triggers for a given table in PostgreSQL.
Return Rows that Only Contain Non-Alphanumeric Characters in SQLite
Here’s an example of returning rows that contain only non-alphanumeric characters in SQLite.
Non-alphanumeric characters include punctuation characters like !@#&()–[{}]:;',?/* and symbols like `~$^+=<>“, as well as whitespace characters like the space or tab characters.
6 Ways to Select Duplicate Rows in SQLite
The following queries can be used to return duplicate rows in SQLite.
Here, the duplicate rows contain duplicate values across all columns, including the ID column.
3 Ways to Create a Table if it Doesn’t Already Exist in Oracle
The very useful CREATE TABLE IF NOT EXISTS syntax was finally introduced in Oracle Database – Oracle Database 23c to be precise. This syntax allows us to run a CREATE TABLE statement without getting an error if the table already exists.
Earlier versions of Oracle don’t support the IF NOT EXISTS clause, and so if we want to avoid any nasty errors resulting from trying to create a table that already exists, we need to do a bit of extra work.
Find Values That Don’t Contain Numbers in MySQL
If you need to return all rows that don’t contain any numbers, the following might help.
Strictly speaking, numbers can be represented by words and other symbols, but for this article “number” simply means “numerical digit”. So we’re finding values that don’t contain any numerical digits.
4 Ways to Select Duplicate Rows in PostgreSQL
If you have a table with duplicate rows in PostgreSQL, you can use any of the following queries to return the duplicate rows.