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

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

Contacts
Email
Twitter
Instagram
Facebook.
Linkedin.

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.

[yunuskureshi]

Great
Thanks a lot for All this tutorials..

[worldofkhyati]

very nice information in this tutorials you so

[jhoncena]

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.

[vimalmudigon]

Manish- Your SQL tutorials are excellent. Please add all functions like trim, replace, mod, reverse, length ect. Thanks in advance.

[dillipverify]

The gr8 Manish...keep it up .
Also try to add PL/sql programming.

[roni]

Very nice tutorials man, thank you. :)

[shaheenshaikh]

How can single row function modify datatypes plz tell

[islamuddinnoorr]

Can you upload the presentation please

[sumitkumar-vnxk]

i want to set my new user name and password that i have done during the installation as i forgot that one....lol..