SQL CHARACTER FUNCTIONS
SQL CHARACTER FUNCTIONS #SQL #CHARACTERFUNCTIONS #LEARNSQL DDL COMMAND #SQL #LEARNSQL #DDL
SQL is a domain-specific language used in programming and designed for managing data held in a relational database management system, or for stream processing in a relational data stream management system.
SQL: Structured Query Language
DDL: Data Definition Language
Learn SQL
CREATE
ALTER
DROP
RENAME
----------------------------------------------------------------------------
DML:DATA MANIPULATION LANGUAGE
INSERT
UPDATE
DELETE
SELECT
DDL COMMAND LINK: • SQL DDL COMMAND #SQL #LEARNSQL #DDL
DML COMMAND LINK: • SQL DML COMMANDS #SQL #DMLCOMMANDS #I...
-----------------------------------------------------------------------------------------------------------------------
3) CHARECTER FUNCTIONS:
INITCAP: USED TO CAPITAL FIRST LETTER
TRIM: USED TO REMOVE SPACE FROM BOTHSIDE OF A CHARECTER
LTRIM:USED TO REMOVE LEFTSIDE SPACE
RTRIM : USED TO REMOVE RIGHTSIDE SPACE
UPPER : USED TO MAKE CAPITAL LETTER(UPPERCASE)
LOWER : USED TO MAKE SMALLER LETTER(LOWERCASE)
NVL : BY USING NVL FUNCTION WE CAN REPLACE NULL VALUE BY SOME OTHER VALUE
IN COMM COLUMN WE NULL VALUE WE CAN REPLACE IT BY THIS FUNCTION
NVL2 : BY USING NVL2 FUNCTION WE CAN REPLACE BOTH NULL AND NOTNULL
VALUE BY SOME OTHER VALUE
NOT NULL VALUE REPLACED BY =200
NUL VALUE REPLACED BY =100
IN OTHER WORDS WE CAN WRITE IT
SUBSTR: BY USING SUBSTR FUNCTION WE CAN GET A PIECE OF CHARECTER
FROM STRING.
HERE WE GET PIECE OF CHARACTER
'1' IS THE START POINT
'3' IS HOW MUCH CHARACTER WE WANT FROM STRING
INSTR:BY USING INSTR FUNCTION WE CAN GET A POSITION OF CHARACTER FROM STRING
BY THIS WE GET POSTION OF CHARACTER
HERE 'A' IS REQUIRED CHARACTER POSITION
FROM WHERE WE REQUIRE TO START INDICATES BY 1,2,3,....
LENGTH: IT WILL RETURNS LENGTH OF THE GIVEN STRING
RETURNS TOTAL NUMBER OF CHARACTER PRESENT IN A STRING
DECODE : BY USING THE DECODE FUNCTION WE CAN CONVERT THE DATA
FROM ONE FORMAT TO ANOTHER
TO MAKE CITY COLUMN RECORD 'BNG' TO 'BANGALORE'
FOR ALIAS NAME WE USE 'AS'
FOR KEEPING OHER RECORDS AS IT IS WE SHOULD KEEP COLUMN NAME AS IT IS
ASCII: RETURNS ASCII OF A CHARACTER
DUAL TABLE CONSISTS ONE ROW AND ONE COLUMN AND ALREADY EXISTS IN DATABASE
ITS ALSO CALLED DUMMY TABLE
--------------------------------------------------------------------------------------------------------------------------
My Youtube Gears :
Best Mic for Recording (Condenser Mic): https://amzn.to/2UUMDnH
Best Mic for Recording (Dynamic Mic ): https://amzn.to/3pQgyvD
My DSLR Camera Canon 200D: https://amzn.to/39ciw3E
My Laptop (Video Editing): https://amzn.to/2UXQj8h
Laptop (Office Use/ Home use / Budget Laptop) : https://amzn.to/3l0pniw
Antivirus: https://amzn.to/3l3TIgi
Screen Recording Software: https://bit.ly/2J39n2j
Video Editing Software: https://bit.ly/3nOPlri
Green screen with Stand: https://amzn.to/2KAl1Cu
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
THANK YOU FOR WATCHING !!!
PLEASE DO SUBSCRIBE FOR MORE UPDATES CLICK ON BELL ICON!!!!!