Oracle SQL,PL/SQL

Character-Manipulative Functions

4 years ago
Add Comment
by shohal
Character-Manipulative Functions
Avatar of shohal
Written by shohal

Character-Manipulative Functions

Character-Manipulative Functions (CONCAT, LENGTH, SUBSTR, INSTR, LPAD, RPAD, TRIM and REPLACE)

Character-Manipulative Functions | TechTweet
These functions manipulate character strings: Function. Result. CONCAT( Hello , World ) HelloWorld. SUBSTR( HelloWorld ,1,5) Hello. LENGTH( HelloWorld ) 10. INSTR( HelloWorld , W ) 6. LPAD(salary,10, ) RPAD(salary, 10, ) 24000 REPLACE ( JACK and JUE , J , BL ) BLACK and BLUE. CONCAT, SUBSTR, LENGTH, INSTR, LPAD, RPAD, and TRIM are the character-manipulation functions that are covered in this lesson. CONCAT: Joins values together (You are limited to using two parameters with CONCAT.) SUBSTR: Extracts a string of determined length. LENGTH: Shows the length of a string as a numeric value. INSTR: Finds the numeric position of a named character. LPAD: Returns an expression left-padded to the length of n characters with a character expression. RPAD: Returns an expression right-padded to the length of n characters with a character expression. TRIM: Trims leading or trailing characters (or both) from a character string (If trim_character or trim_source is a character literal, you must enclose it within single quotation marks.) Note: You can use functions such as UPPER and LOWER with ampersand substitution. For example, use UPPER( &job_title )so that the user does not have to enter the job title in a specific case. TRIM( H FROM HelloWorld ) elloWorld. Oracle Database: SQL Fundamentals I

You may also like

About the author

Avatar of shohal

shohal

I have profession and personal attachment with custom ERP Software development, Business Analysis, Project Management and Implementation almost (36) ,also Oracle Apex is my all-time favorite platform to developed the software. Moreover i have some website development experience with WordPress. For hand on networking experience DevOps and CCNA, it create me a full package. Here are some core programming language with networking course i have been worked: Oracle SQL ,PL/SQL,Oracle 19c Database , Oracle Apex 20.1,WordPress,Asp.Net ,MS SQL ,CCNA ,Dev Ops, SAP SD

View all posts

Leave a Comment