Search
 
SCRIPT & CODE EXAMPLE
 

SQL

ORACLE PARSE STRING

-- 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 :: what is union in sql 
Sql :: sql truncate number 
Sql :: in operator in sql 
Sql :: full outer join in sql 
Sql :: while in plsql 
Sql :: how to find constraints on a table in oracle 
Sql :: modify column name in tsql 
Sql :: how to create foreign key in sql server management studio 
Sql :: delete in sql server 
Sql :: sql first day quarter 
Sql :: bigquery javascript 
Sql :: get id from just inserted row mysql server python 
Sql :: get url of cpanel database hostname 
Sql :: multiple tricky query in sql server 
Csharp :: reload scene unity 
Csharp :: c# change label forecolor code 
Csharp :: aabb collision 
Csharp :: unity key detection 
Csharp :: vb.net wait 1 second 
Csharp :: unity get layer of gameobject 
Csharp :: check connection c# 
Csharp :: unity check for internet connection 
Csharp :: c# datetime dd/mm/yyy hh:mm:ss 
Csharp :: print in c# 
Csharp :: spawn a object with unity 
Csharp :: onafterrender blazor 
Csharp :: sconvert string to title case + C3 
Csharp :: how to destroy object in unity c# 
Csharp :: c# tostring mmm dd yyyy 
Csharp :: playerInputManager.JoinPlayer(....) 
ADD CONTENT
Topic
Content
Source link
Name
2+9 =