HomeОбразованиеRelated VideosMore From: Manish Sharma

Oracle Database11g tutorials 11: SQL case manipulation function in Oracle Database

367 ratings | 84773 views
Part 2 SQL functions- character function -case manipulation functions Previous Video Link :: http://youtu.be/5rx8Q4x4-qI Tool used in this tutorial is command prompt. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ------------------------------------------------------------------------------------- As discuss in last video we have 3 case manipulation functions. In case you miss the SQL functions intro video you can find the link in the description below. First let's see what these functions are. Upper (): This function takes a parameter converts it into uppercase and returns the new string. Initcap (): this function also takes parameter and converts the initial letter of or parameter into uppercase and returns the new string. Lower (): This function takes a parameter converts it into lowercase and returns the new string. Ok let's do some practical For this practical we will be using 2 tables First is dual table Which is a dummy table provided by oracle? And I have created another table again by the name of example. This will be our second table. Let's start with SQL function upper ( ); SELECT upper('hello world') FROM dual; As you can see I have used "hello world" completely in lowercase as parameter to SQL upper function. Execute it. Here, our result has given us a completely new hello world string which is in uppercase. Similarly you can also use SQL upper function to perform other DML Let's try This time we will work on our second table EXAMPLE; insert into example values (upper('manish')); first parentheses for values and second for SQL function upper. Let's check the result. As you can see here inserted value is in upper case. Lets compare it with simple insert query Insert into example values ('manish'); Execute it, i think now it's clear that when we perform simple insert DML the inserted value will be the same you provide. Similarly let's try SQL function initcap(); SELECT initcap('hello world') FROM dual; As you see here in result the initial letters of string hello world are in uppercase. Let's do the insert query insert into example values (initcap('hello world')); initial letters of string also are in uppercase. Let's try SQL function lower(); This time we have to write our hello world in all caps. SELECT lower('HELLO WORLD') FROM dual; Execute String totally in lower case. Similarly you can user SQL function lower in other DML like insert and all.
Html code for embedding videos on your blog
Text Comments (26)
racer (14 days ago)
What does " dual" here refer to?
Thank you bro. You are a Captain ;)
Nanang Dwi Setiadi (6 months ago)
Hello Manish, I've watched a lot of your videos in this chenel. but I have an unresolved problem. I want to know how to create a capital character at the end of a name. for example: initcap (first_name) the result -> "Steven". but how to make the letter "N" in the name Steven into capital letters. the result "SteveN" ?? thanks Manish, keep on making tutorials to help everyone :-).
Istiak Ahmad (7 months ago)
what is dual ???
Vittorio Sozzi (1 year ago)
Whats exactly is the 'dual' table you're selecting from in the first upper() example?
sandeep dubey (1 year ago)
Hey manish your videos are really awesome,but along with this if you can upload some notes related to this some ppts or some materials for future reference then it would be great !!!!!
Abhishek Saha (1 year ago)
while running the below sql command create table example(column varchar2(30)); I am getting the below error Error starting at line : 13 in command - create table exemp (column varchar2(20)) Error report - SQL Error: ORA-00904: : invalid identifier 00904. 00000 - "%s: invalid identifier" *Cause: *Action: However if I remove the column by col the query is executed successfully and the table is created. Can you tell me what is wrong with the "column"
Upkar chaudhary (5 months ago)
column is a reserve keyword by sql which can not be use.
Divya B (1 year ago)
HI, In the result set, you are getting "table example truncate". What does it mean??
Sami Say (2 years ago)
do you have videos about oracle10g administration? thx
Krupa Patel (2 years ago)
Love how your videos are short and simple. Very Helpful. Thanks for your hard work.
Manish Sharma (2 years ago)
I am glad that you liked my videos. Thank you very much for your appreciation.
Durgesh Parlewar (2 years ago)
sir , I have face problem when I create table ora-00955 name already used by existing object vendor code 955
Durgesh Parlewar (2 years ago)
well job Manish u rocks.
Manish Sharma (2 years ago)
Thank you so much
Salah Ali Abdi (2 years ago)
Nice Explanation Manish Sir
Sneha Mamillapalli (2 years ago)
Hi Manish Is it possible to modify the entire entries in a column from one case to another case using the character function?
dananasyh (2 years ago)
thnk you manish
GAURAV KANAUJIA (2 years ago)
Thanks Manish it's great
RamaKrishna Arikatla (2 years ago)
thank you manish it was really helpful
Manish Sharma (2 years ago)
+RamaKrishna Arikatla Your comment has become the star comment of the day :-) and is being featured with #MorningMotivation on all my social media. Make sure to visit and Check My Twitter: https://twitter.com/RebellionRider My Facebook: https://www.facebook.com/imthebhardwaj
Manish Sharma (2 years ago)
+RamaKrishna Arikatla Thank you so much. I am glad you find my video helpful. Please don't forget to Like and Share.(y)
Khyati Patel (3 years ago)
samhita khanuja (3 years ago)
Well done dude. This is really very helpful..k appreciate your efforts and to be honest I like very few YouTube tutorials..and for u it's a full power thumbs up..awesome work .keep it up. :)
Megha Misra (3 years ago)
Hi Manish i'm preparing for 1z0-051 exam do you have any suggestion for that exam?booked the exam for next week but don't know if i'm fully prepare. Can you please help me to know the keys I' mean what are the topics cover in the exam.
efrain lirio (3 years ago)
Hi Manish, how are you? Am speaking from Brazil and am preparing to 1z0-047 oracle exam, can you send the especific videos to help my dream come true? Thanks a lot Efrain Lirio

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.