Count no. of characters and words in a string in PL/SQL

Concatenation of strings in PL/SQL

Last Updated : 03 Jul, 2018

Prerequisite - PL/SQL Introduction In PL/SQL code groups of commands are arranged within a block. A block group related declarations or statements. In declare part, we declare variables and between begin and end part, we perform the operations. Given two strings and the task is to concatenate them and store it in another string. Examples:

Input: str1 = ' RAMESH', str2 = 'SURESH'
Output: RAMESH SURESH

Input: str1 = ' Ramesh is a good boy', str3 = 'and',
       str2 = 'Suresh is a brilliant student'.
Output: Ramesh is a good boy and Suresh is a brilliant student

Approach is to use the concatenation operator i.e. || . Below is the required implementation:

SQL

 DECLARE
    --Here variables are str, str1, str2 and v
    str  VARCHAR2(40) := 'Ramesh is a good boy';
    str1 VARCHAR2(40) := 'Suresh is a brilliant student';
    str2 VARCHAR2(40) := 'and';
    v    VARCHAR2(100);
BEGIN
    v := str
         ||' '
         || str2
         ||' '
         ||str1;

    dbms_output.Put_line(v);
END;
-- Program End

Output:

Ramesh is a good boy and Suresh is a brilliant student

Count no. of characters and words in a string in PL/SQL

S

Shashank12

Improve

Article Tags :

Practice Tags :

Misc

Similar Reads

Concatenation of two strings in PHP

In this article, we will concatenate two strings in PHP. There are two string operators. The first is the concatenation operator ('.'), which returns the concatenation of its right and left arguments. The second is the concatenating assignment operator ('.='), which appends the argument on the right

Count no. of characters and words in a string in PL/SQL

Prerequisite - PL/SQL introduction In PL/SQL code groups of commands are arranged within a block. A block group related declarations or statements. In declare part, we declare variables and between begin and end part, we perform the operations. Given a string and the task is to count the number of c

SQL | Concatenation Operator

The SQL concatenation operator (||) is a powerful feature that allows us to merge two or more strings into a single output. It is widely used to link columns, character strings, and literals in SQL queries. This operator makes it easier to format and present data in a user-friendly way, combining mu

No. of vowels and consonants in a given string in PL/SQL

Prerequisite - PL/SQL introduction In PL/SQL code groups of commands are arranged within a block. A block group related declarations or statements. In declare part, we declare variables and between begin and end part, we perform the operations. Given a string and the task is to find the number of vo

Using REPLACE Function in SQL

In Structured Query Language (SQL), the REPLACE function is used to replace a substring or a part of a string within the given String. While dealing with some data pre-processing tasks or some data cleaning tasks, the REPLACE function is found to be very useful. It can save a lot of time and it also

CONCAT_WS() Function in MySQL

CONCAT_WS() : This function in MySQL helps in joining two or more strings along with a separator. The separator must be specified by the user and it can also be a string. If the separator is NULL, then the result will also be NULL. Syntax : CONCAT_WS(separator, string1, string2, ...) Parameters : se

SUBSTRING() function in MySQL

SUBSTRING() : function in MySQL is used to derive substring from any given string .It extracts a string with a specified length, starting from a given location in an input string. The purpose of substring is to return a specific portion of the string. Syntax : SUBSTRING(string, start, length) OR SUB

Using LENGTH() Function in SQL

Understanding the length of strings within a database is a fundamental aspect of effective data management and analysis. In the world of SQL, the LENGTH() function provides an essential tool for measuring the number of characters in a string, which can be invaluable for various tasks such as data va

Inbuilt Concat Function in PLSQL

Prerequisite : PLSQL BASICS Introduction : PLSQL stands for "Procedural Language extensions to SQL" and is used to transform, update and query data in a database. It is grouped into blocks that contain the declaration and statements. And it is integrated with the oracle database (since version 7). A

CONCAT_WS() Function in SQL Server

CONCAT_WS() : This function concatenates two or more strings together with a separator. Syntax : CONCAT_WS(separator, input_string1, input_string2, [...input_stringN]); Parameter : This method accepts two-parameters as mentioned above and described below as follows. separator - It is an expression o