Skip to content

Coder Tutorial

Menu
  • Home
  • HTML
  • CSS
  • PHP
  • SQL
  • MySQL
  • JS
  • PL/SQL
  • Python
  • Java
  • Oracle
Home
Oracle
Oracle TRIM

Oracle TRIM

The Oracle TRIM function enables you to trim leading or trailing characters (or both) from a character string.

Oracle TRIM example

select 
trim(' tutorial ') 
from dual;

Result: 'tutorial'

select 
trim(leading '1' from '111089711091') 
from dual;

Result: '089711091'

select 
trim(trailing '9' from 'Oracle9') 
from dual;

Result: 'Oracle'

select 
trim(both '1' from '111Oracle10G11') 
from dual;

Result: 'Oracle10G'

Tutorials

  • Oracle Tutorial
  • Oracle Create Table
  • Oracle Insert
  • Oracle Update
  • Oracle Delete
  • Oracle Anonymous Block
  • Oracle Data Types
  • Oracle Conditional Statements
  • Oracle Transaction Statements
  • Oracle Loop Statements
  • Oracle Cursors
  • Oracle Create Procedure
  • Oracle Create Function
  • Oracle Create Package
  • Oracle Create View
  • Oracle Create Trigger
  • Oracle Exception

Recent Posts

  • Java Polymorphism
  • Java Encapsulation
  • Java Abstraction
  • PostgreSQL ERROR: cannot begin/end transactions in PL/pgSQL
  • PostgreSQL Column must appear in the GROUP BY clause
  • PostgreSQL Column specified more than once
  • PostgreSQL Create database, Alter database examples
  • PostgreSQL Create schema syntax, Alter schema
  • PostgreSQL Create database user, alter and drop username
  • PostgreSQL Alter table name. Modify column name
Coder Tutorial Copyright © 2025. | Privacy Policy
Back to Top ↑