Knowledge Hub — Technical Document

Generated on 2026-08-28 06:58 | Confidential Client Asset

String Functions

Published July 26, 2025 By Sai Sree Ram Gundepudi

Common String Functions in Oracle SQL

  • UPPER(), LOWER(), INITCAP() – change case
  • SUBSTR(str, start, length) – extract substring
  • INSTR(str, substr) – find position
  • LENGTH(str) – length of string
  • CONCAT(str1, str2) – combine strings
SELECT UPPER('oracle'), LENGTH('sql functions'), SUBSTR('Hello World', 1, 5) FROM dual;

Was this solution helpful?

Your feedback helps improve our technical knowledge repository.

Share this article

You may also like

String Functions

Working with String Functions in MySQL

ExamplesSELECT CONCAT(first_name, ' ', last_name) AS full_name FROM employees; SELECT LENGTH('MySQL'); SELECT SUBSTRING(...