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

Oracle Database11g tutorials 10 || SQL Single Row Function (SQL Functions )

302 ratings | 98786 views
Single row functions 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 Email [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 The Code makers ============================================ in this oracle database tutorial we will see what are SQL FUNCTIONS. SQL functions are divided into two categories 1st is Single Row Functions And another one is Multiple row function which is also known as aggregate functions. But in today's SQL tutorial we will concentrate on Single Row Functions. Single-row functions operate on one row at a time and return one row of output for each input row. Single row functions are capable of manipulating data items and modifying the data types. Single row functions return one result per row and act on each row that is returned. Single row functions can accept one or more arguments and return one value. These arguments can be a column or an expression. With oracle we have 5 types of Single Row Functions 1. Character Functions 2. Number Functions 3. General Functions 4. Conversion Functions and 5. Date Functions. Character Functions are further divided into two categories. 1st is Case- manipulation functions and 2nd is Character Manipulation functions. We have 3 case manipulation functions Lower, upper and initcap and 7 character manipulation functions Sql functions concat, substr, length, instr, lpad, rpad, trim and replace. In our future video we will see what these functions are and what they do along with other SQL function. That's it for today's sql tutorial. Hope you enjoyed watching. Please don't forget to subscribe and like. Have a good day. This is Manish.
Html code for embedding videos on your blog
Text Comments (14)
Shaheen Shaikh (16 days ago)
How can single row function modify datatypes plz tell
Sainath V (7 months ago)
Excellent Videos..U r a great rider
jhon cena (1 year ago)
Your tutorials are good but the only problem is that your speed is very fast, anyway thanks for making these videos, I have learnt alot from you.
AVINASH SINGH (2 years ago)
sumit kumar (2 years ago)
i want to set my new user name and password that i have done during the installation as i forgot that one....lol..
Islamuddin Noor (2 years ago)
Can you upload the presentation please
roscoe jr (3 years ago)
THANKS BRO..........................SUBSCRIBED
yunus kureshi (3 years ago)
Great Job............. Thanks a lot for All this tutorials..
Khyati Patel (3 years ago)
very nice information in this tutorials ...............thanks you so much.........
Vimal Mudigon (3 years ago)
Manish- Your SQL tutorials are excellent. Please add all functions like trim , replace, mod, reverse, length ect. Thanks in advance.
Ronildo Andrade (4 years ago)
Very nice tutorials man, thank you. :)
Dillip Mohapatra (4 years ago)
The gr8 Manish...keep it up . Also try to add PL/sql programming.
S Wadhwa (4 years ago)
Manish Sharma (4 years ago)
@S Wadhwa Thanks a lot :)

Would you like to comment?

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