Search
 
SCRIPT & CODE EXAMPLE
 

SQL

oracle substring

-- ORACLE substr(string, start, [, length ])
SELECT substr('Hello World', 4, 5) FROM DUAL;       -- lo Wo
SELECT substr('Hello World', 4) FROM DUAL;          -- lo World
SELECT substr('Hello World', -3) FROM DUAL;         -- rld
SELECT substr('Hello World', -3, 2) FROM DUAL;      -- rl
Comment

ORACLE SUBSTRING SYNTAX

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

Comment

PREVIOUS NEXT
Code Example
Sql :: How to get number of months between 2 dates sql server 
Sql :: how to fetch first 10 rows in sql 
Sql :: mysql faster insert 
Sql :: stored procedures example 
Sql :: connect to remote mysql server 
Sql :: oracle find constraints referencing a table 
Sql :: mysql order by desc 
Sql :: what is sql clause 
Sql :: max in postgresql 
Sql :: oracle sql first day of quarter 
Sql :: bigquery routine 
Sql :: pl/sql how to delete a trigger 
Sql :: check if two tables are identical sql 
Sql :: ffeathers express mysql application users login 
Csharp :: how ot make a variable public without showing in the inspector 
Csharp :: unity hide mouse 
Csharp :: c# sleep 
Csharp :: how to edit text mesh pro text 
Csharp :: unity button onclick remove listener 
Csharp :: object spin unity 
Csharp :: c# preprocessor if not 
Csharp :: set width of rect transform unity 
Csharp :: c# serialize json 
Csharp :: c# print to console 
Csharp :: writeline c# 
Csharp :: setup authorize in swagger .net core 
Csharp :: xamarin button text lowercase 
Csharp :: unity inspector how to get larger field for string text 
Csharp :: how to reference scripts in other scenes unity 
Csharp :: c# string capital first letter extension method 
ADD CONTENT
Topic
Content
Source link
Name
4+3 =