#sql #sqlinterview #sqlinterviewquestionsandanswers #sqlbeginners #sqltutorial
SQL Tricky Interview Question || SQL Tutorials || SQL Learning
Requirement:
First Letter only should be in Upper case and remaining should be in Lower case:
CREATE TABLE PRAVEEN_TRAINING_TABLE AS
SELECT 'SQL RealTime TraiNING' COURSE FROM DUAl
UNION ALL
SELECT 'PLSQL Developer TraiNING' FROM DUAl
UNION ALL
SELECT 'SnowFLAKE Data Engineer' FROM DUAl
UNION ALL
SELECT 'python TraiNING' FROM DUAl;
SELECT * FROM PRAVEEN_TRAINING_TABLE;
Logic:
Step 1 – Extract 1st Letter of All the Records using SUBSTR
Step 2 – Using Upper Function, convert the first letter to Upper
Step 3 – From 2nd character, extract all the characters using SUBSTR
Step 4 – Using Lower Function, make the remaining all characters to small case
Step 5 – By using CONCAT or ||, Club 2 strings into single String
