Search
 
SCRIPT & CODE EXAMPLE
 

SQL

oracle right characters

-- For Oracle only

-- syntax 
SUBSTR(<main-string>,-<number-of-characters>)

-- example 
SUBSTR('Useless stuff',-9) -- OUTPUT: ess stuff

-- practical example
SELECT SUBSTR('Useless stuff',-9)
FROM DUAL;
Comment

PREVIOUS NEXT
Code Example
Sql :: count the table indatabase 
Sql :: oracle last modification in table 
Sql :: mongodb vs mysql 
Sql :: get table column names sql 
Sql :: postgressum when 
Sql :: sql left join 
Sql :: ignore case in string sql 
Sql :: timestamp difference sql 
Sql :: get locked tables sql server 
Sql :: functions with parameters SQL 
Sql :: select the date 30 days less that the todays date sql request 
Sql :: postgresql concat string with separator 
Sql :: access no password in mysql mamp 
Sql :: postgresql database url 
Sql :: sql query inner join 3 tables 
Sql :: sql unique constraint 
Sql :: sql create table 
Sql :: sql update record 
Sql :: on update current_timestamp jpa 
Sql :: bigquery timestamp 
Sql :: mysql join two tables 
Sql :: postgres date 
Sql :: export mysql table to file 
Sql :: nested query sql 
Sql :: fk in insert mysql 
Sql :: update row postgres 
Sql :: creating sql table 
Sql :: what data type to use for phone number in sql 
Sql :: SQL Syntax of INNER JOIN 
Sql :: get specific column in mongodb 
ADD CONTENT
Topic
Content
Source link
Name
7+7 =