Sql

-- ORACLE SQL - Get the 2 digits at the RIGHT end of a string
SELECT SUBSTR('TN0001234567890345',-2) FROM DUAL;

-- ORACLE SQL - Get the 2 digits at the LEFT end of a string
SELECT SUBSTR('TN0001234567890345',1,2) FROM DUAL;

PREVIOUS	NEXT

Code Example
Sql :: SQL Integer devision
Sql :: sql like variable
Sql :: how to delete view in sql
Sql :: upload database mysql command line
Sql :: what is meant by trigger in dbms
Sql :: hibernate dialect property xml for mysql 8
Sql :: how to check database username and password in postgresql
Sql :: Postgres upgrade to superuser
Sql :: postgres convert exisiting column to text
Sql :: console output pl sql
Sql :: fill a column in database with a value
Sql :: liquibase update row
Sql :: oracle aleter trigger ora-01031
Sql :: sql remove first character from string
Sql :: mysql reset auto increment
Sql :: sql comment header
Sql :: psql human readable
Sql :: mysqldump csv
Sql :: show table columns
Sql :: oracle apex list connected users
Sql :: how do you use sql in you company
Sql :: sql string_agg
Sql :: sql get number of days between two dates
Sql :: woocommerce mysql price table
Sql :: mysql update inner
Sql :: add timestamp column to existing table t-sql
Sql :: get week day name sql server
Sql :: ora-00054 resource busy and acquire with nowait
Sql :: update query formula in excel
Sql :: add auto increment column mysql