filmov
tv
UPPER LOWER INITCAP in SQL || Lesson 56 || DBMS || Learning Monkey ||

Показать описание
In this class, we will understand UPPER LOWER INITCAP in SQL.
We have already discussed the concepts of CONCAT.
UPPER, LOWER, INITCAP in SQL
LOWER: Converts every letter in the string to lower case.
UPPER: Converts every letter in the 'string' to upper case.
INITCAP: Initial Capital. Capitalizes the first letter of the word or a series of 'words.'
SELECT UPPER(name), LOWER(name), INITCAP(name) FROM students;
The output of the query is as shown below.
#learningmonkey #dbms #placements #gatecse #gatedbms #campusplacements
Link for playlists:
We have already discussed the concepts of CONCAT.
UPPER, LOWER, INITCAP in SQL
LOWER: Converts every letter in the string to lower case.
UPPER: Converts every letter in the 'string' to upper case.
INITCAP: Initial Capital. Capitalizes the first letter of the word or a series of 'words.'
SELECT UPPER(name), LOWER(name), INITCAP(name) FROM students;
The output of the query is as shown below.
#learningmonkey #dbms #placements #gatecse #gatedbms #campusplacements
Link for playlists:
23. using UPPER and LOWER FUNCTION in SQL
UPPER LOWER INITCAP in SQL || Lesson 56 || DBMS || Learning Monkey ||
UPPER, LOWER AND INITCAP IN SQL ORACLE TUTORIAL|STRING FUNCTIONS
Oracle Tutorial - Case Manipulation Functions | UPPER | LOWER | INITCAP
Oracle CASE Manipulation | UPPER | LOWER | INITCAP | Oracle Tutorial for Beginners
Single Row Function in SQL(Upper Lower Initcap)
SQL Journey 14: Single Row Function || Char Part-1 (SQL: UPPER, LOWER, INITCAP)
Oracle SQL How to use Character Functions (UPPER, LOWER, INITCAP) Part 2 - Lesson 35
LOWER and UPPER Function in SQL
Lower, Upper and INITCAP functions in SQL || What are Functions in SQL?(Oracle SQL) | SQL tutorial
SQL Character Functions UPPER, LOWER, INITCAP, CONCAT, SUBSTR, LENGTH, INSTR, LPAD, RPAD, TRIM(2020)
10 Srting Function in Oracle SQL | UPPER LOWER INITCAP DECODE CASE | #SQLTutorial #StringFunctions
41 - SQL - LOWER CASE
Oracle SQL How to use Character Functions (UPPER, LOWER, INITCAP) Part 1 - Lesson 34
Snowflake SQL Essential: Understanding Upper, Lower, InitCap Functions
SQL Lec4: Single Row Functions| Character Functions| Case Conversion | Upper, Lower, InitCap
Основы SQL. Урок 10. LOWER, UPPER, INITCAP, CONCAT.
Funções LOWER, UPPER e INITCAP
Character Single Row Function (Part 1) (UPPER, LOWER, INITCAP, CONCAT, LENGTH,) || SQL (14)
SQL Giriş - 6 (UPPER,LOWER,INITCAP)
Oracle11g SQL Tutorial 8 use of lower, upper, initcap, concat & substr function
7.2 Single-Row Functions [Character Functions Case Conversion LOWER, UPPER, INITCAP Functios]
Oracle Tutorial - How to handle Lower, Upper and Mixed case in SQL Queries
SQL PART 16 - WORKING WITH CHARACTER FUNCTIONS (LENGTH,INSTR,SUBSTR,REPLACE,INITCAP,UPPER,LOWER)
Комментарии