This video we are going to discuss the NUMBER data type. The Number data type is used to store integers, and real numbers. When you create a column as a NUMBER, you can store pretty huge or pretty small numbers in this column. Now there are two things you need to consider when working with numbers, and that is the precision as well as the how big the number is.
For example, we can store the number 9.9. This has two significant digits. We could also store the number 9.9 X 10^4. In this situation, the number is much larger, but the number of significant digits is the same. 9.9 are the significant digits. When we expand this out we just have 99000, and the zeros are just used for size and are not considered "significant" in this situation. In fact, you get a max precision of 38, but a maximum value of 9.99 * 10^125. You can also use this data type to store very small numbers. Check the docs for the specifics on maximums and minimums.
You can provide it with two pieces of information:
Precision - The total number of digits.
Scale - The number of digits to the right of the decimal.
You do it in this format: NUMBER (precision, scale).
The important thing to remember in this is that when you specify a precision, you will be limiting the max size of the numbers.
The secret behind this data type is that it is actually stored in scientific notation. That is we store a number and then we can multiply it by 10 raised to some power. This allows us to store much larger numbers without taking up a ton of space.
The oracle docs actually gives a formula that you can use to see how much storage is going to be required for a specific NUMBER data type.
How much precision can be used? The acceptable range is 1-38.
What about scale? The range is actually -84 to 127. I'll explain the scale in more detail in an upcoming video. That's because there is a lot of confusing things here…What does it mean for the scale to be negative? How can we have a scale that is bigger that the total number of digits available through the precision. That's a topic for another video.
It's important to understand that when we increase our scale, we decrease the max size of the number. For example if we have a precision of 5 and a scale of 3, the highest number we can store is 99.999. This is in contrast to a precision of 5 and a scale of 2 which allows for up to 99.999. Either way you get 5 significant digits, but the numbers of digits to the left and right of the decimal change.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Support me! http://www.patreon.com/calebcurry
Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter
Donate!: http://bit.ly/DonateCTVM2.
~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~
More content: http://CalebCurry.com
Facebook: http://www.facebook.com/CalebTheVideoMaker
Google+: https://plus.google.com/+CalebTheVideoMaker2
Twitter: http://twitter.com/calebCurry
Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)

Views: 6886
Caleb Curry

Every column within a table has to be given what is known as a datatype. A data type is a fairly simple concept when you dissect the word. It is literally the type of data. Why do we use types, though? The biggest benefit is so that Oracle knows how to interpret and work with our data. It also makes the database better at rejecting incorrect data.
If we had to concept of a data type, there would be a lot more work involved in forcing data to be of the right format. It would also be harder for us to get the database to treat the data in the correct way.
In addition to this, a database can optimize storage and performance for a column if everything is of the same data type. Because of this, each column can only support one data type.
There are numerous different data types in Oracle and it helps us if we categorize them.
The first types of datatypes we should learn about are:
String,
Numeric,
Temporal
Now, there are few more categories we could make, but these are the main ones. We will worry about the other ones another day as I am only introducing the topic.
A string data type is anything within quotes. Most databases use single quotes for string data. Inside of the quotes can be any number of characters. What is a character? Think of any letter, number, or symbol you can type. Some people call these letters, numbers, and symbols alphanumeric.
Numeric data type includes only numbers. These data types are often used for data that you plan on using for mathematical calculations.
Temporal data types are data types that are used for dates and times.
Now, each data type is probably going to have some options you'll need to worry about, but one that comes up with every data type is storage. The reason we need to consider storage is because we may end up with millions of rows in a table and the difference between a few bytes for each row will make a huge difference when we look at the whole picture. When a data type gives you the option of size, you will want to a size that will be able to hold what you need, but nothing more.
In the upcoming videos we are going to discuss the available data types in more detail.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Support me! http://www.patreon.com/calebcurry
Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter
Donate!: http://bit.ly/DonateCTVM2.
~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~
More content: http://CalebCurry.com
Facebook: http://www.facebook.com/CalebTheVideoMaker
Google+: https://plus.google.com/+CalebTheVideoMaker2
Twitter: http://twitter.com/calebCurry
Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)

Views: 6528
Caleb Curry

In this tutorial we';; check out the data type options we have available for use in SQL. We'll talk about Bigint, int, smallint, tinyint, decimal, number, float, char, varchar, blob, datetime, date, time and year.

Views: 95225
The Bad Tutorials

Session 6:
Datatypes In Oracle
ALPHABET : A-Z , a-z
NUMBER : 0-9 (with precision and scale)
DATE / Temporal : any Date and time (Hours, Minutes, Seconds, Mili-seconds, Timestamp, Timezone etc)
Alphabet + Number = Alphanumeric Data
= String / CHARACTER Datatype Category
Number = Numeric Datatype Category
Date = Date Datatype Category
1. CHARACTER Datatype:
CHAR, VARCHAR, NCHAR:
CHAR is fixed length datatype and VARCHAR is Variable length datatype to store character data. i.e. A-Z , a-z , 0-9 , all keyboard characters etc.
The default size is 1 character and it can store maximum up to 2000 bytes.
Example : EName, EmpID, PassportNo, SSN, etc.
EName CHAR(10) := ‘TOM’; wastage of 7 space after the string
EName VARCHAR(10) := ‘TOM’; Spaces can be Reuse which left after the string
NCHAR additionally handles NLS(National Language Support).
Oracle supports a reliable Unicode datatype through NCHAR , NVARCHAR2 , and NCLOB
VARCHAR2, NVARCHAR2:
These are Variable length datatype.
VARCHAR2 handles alphanumeric character string whereas NVARCHAR2 handles alphanumeric character string with NLS(National Language Support).
The default size is 1 character and it can store maximum up to 4000 bytes.
LONG: Variable length string. (Maximum size: 2 GB - 1)
Only one LONG column is allowed per table.
RAW: Variable length binary string (Maximum size 2000 bytes)
LONG RAW: Variable length binary string (Maximum size 2GB)
2. NUMERIC Datatype:
NUMBER:
It stores Numeric values and performs numeric calculations.
NUMBER, NUMBER(n), NUMBER(p,s)
It stores Numbers up to 38 digits of precision.
SeqNo NUMBER; 1, 123, 12345678
EmpID NUMBER(4); 1, 123, 1234
Sal NUMBER(7,2); 23456.78 , 123.45 — correction in video: Sal NUMBER(a7,2); which is wrong please ignore.
1234567 can be a type of NUMBER, NUMBER(7), NUMBER(7,0)
It can store both integer and floating point numbers
NUMERIC(p,s)
FLOAT: Ex: EmpSal FLOAT; FLOAT(7) Decimal Points allowed
DEC(p,s), DECIMAL(p,s) , REAL, DOUBLE PRECISION
INTEGER: Ex: SSN INTEGER; Decimal Points are not allowed
INT, SMALLINT
3. DATE Datatype:
DATE:
It stores DATE(Date, Month, Year) and Time(Hour, Minute, Second, AM/PM) and performs calculations with such data.
Default DATE format in Oracle is “DD-MON-YY”
Based on "Gregorian calendar" where the date ranges from “JAN 1 4712 BC” to “DEC 31 9999 AD”
doj DATE; “18-MAR-2010 12:30:00 PM”
TIMESTAMP: It can store all parameters as DATE datatype and additionally it can have “Fraction of seconds” and
TIMESTAMP WITH TIMEZONE / TIMESTAMP WITHOUT TIMEZONE.
Range from 0-9 digits, the default size is 6.
4. LOB Datatype:
LOB: “Large Object” data.
It can store pictures, motion pictures, Textfiles etc.
CLOB: “Character Large Object” is used to store structured information like a text file with a specific file format.
BLOB: “Binary Large Object” is used to store Un-structured information like Image, JPEG files, MPEG files etc.
BFILE: “Binary File” is used to store the pointer to a specific file / Just store the location of a file.
Maximum size: (4 GB - 1) * DB_BLOCK_SIZE initialization parameter (8 TB to 128 TB)
Extra Information:
NCLOB : It supports all the character set supported by CLOB and additionally it handles NLS(National Language Support )
Maximum size: (4 GB - 1) * DB_BLOCK_SIZE initialization parameter (8 TB to 128 TB)
ROWID and UROWID(optional size) Datatype: contains fixed length Binary data.
BBBBBBB.RRRR.FFFFF combination of BLOCK-ROW-DATABASE FILE
Physical and Logical ROWID
Upcoming Session:
Session 7:
Populating Data into Tables(INSERT Statement):
Inserting data into all columns of a table
Inserting data into Required columns of a table
Inserting NULL value into a table
Inserting Special Values(USER / SYSDATE) into a table
Supplying data at runtime(using & and &&)
THANK YOU :)

Views: 57
Database Concepts Made Easy

In the upcoming videos we are going to discuss data types in depth, but I don't want to drown you in all of the details. Because of that, I'm giving you this video which is going to introduce you to the most important data types. Then, in the upcoming videos, I'll describe them in more depth.
One of the data types we've already discussed in this video is NUMBER. This data type is used to, obviously, store a number. It can be used to store integers (whole numbers), or numbers with decimals. There are two other numeric data types you should know of.
BINARY_FLOAT and BINARY_DOUBLE are both numeric data types that are known as floating point numbers. A floating point number is often used for large numbers that have decimal places where it is acceptable to not be completely precise. What I mean by this is that these numbers can only store numbers correctly up to a certain decimal point. If you need perfect precision, you will want to use the NUMBER data type.
Now storing numbers is good sometimes, but occasionally you will want to store string data. String data can be any sequence of characters, including numbers. By telling the database that a column is a string data type, the database knows how to treat that column. There are four important string data types that you need to know about.
The first two are CHAR and NCHAR. These data types are used to store a fixed-length string. So for example, you can say you want to store 12 characters. This means that every value for this column will be exactly 12 characters. If you insert less than 12 characters, the data will be padded with spaces. This means you will want to use one of these data types when every value in the column is the same length. What is the difference between CHAR and NCHAR? CHAR uses what is known as ASCII while NCHAR uses Unicode. The difference is what characters are allowed and how much space each character takes. ASCII takes up less space but only supports English, numbers, and some symbols. UNICODE allows you to store characters from multiple languages but takes up more space.
Those were both fixed-length string. What if you want to store data that changes in length? That is where VARCHAR2 and NVARCHAR2 come in.
When it comes to storing dates, the data types that are most important are DATE and TIMESTAMP. Date can be used to store dates and time. Timestamp is a data type that can be used to store an exact moment in time.
Lastly, there are interval types. These store a date range.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Support me! http://www.patreon.com/calebcurry
Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter
Donate!: http://bit.ly/DonateCTVM2.
~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~
More content: http://CalebCurry.com
Facebook: http://www.facebook.com/CalebTheVideoMaker
Google+: https://plus.google.com/+CalebTheVideoMaker2
Twitter: http://twitter.com/calebCurry
Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)

Views: 5486
Caleb Curry

Learn about The Numeric Data Type in MySQL with Examples
Int
TinyInt
SmallInt
MediumInt
BigInt
Float
Decimal
Real
BIt
Boolean

Views: 17041
Elzero Web School

See more at http://www.highercomputingforeveryone.com -- In this lesson I introduce several numeric data types in the C programming language.

Views: 23783
Carl Herold

In this video you'll be taught about the DECIMAL, NUMERIC, FLOAT, DOUBLE and REAL Data Types.

Views: 1224
Coding Senpai

https://www.databasestar.com/oracle-to_number/
The Oracle TO_NUMBER function is used to convert a text value into a number value.
It’s similar to TO_CHAR and TO_DATE, but converts a value to a number.
The number will also be rounded to a specified number of digits, and returned as a NUMBER value.
The syntax is:
TO_NUMBER( input_value, [format_mask], [nls_parameter] )
The input_value is the value to be converted to a number. Commonly this is provided as a string (e.g. CHAR or VARCAHR2) but can be several other data types as well.
The format_mask is the format that the output value should be displayed as. It must be a valid number format. This is an optional value.
The final parameter, nls_date_language, is used to work out how the output is displayed, such as how to display currency symbols. It’s also an optional value.
For more information about the Oracle TO_NUMBER function, including all of the SQL shown in this video and the examples, read the related article here:
https://www.databasestar.com/oracle-to_number/

Views: 1969
Database Star

Oracle tutorial : Conversion Functions In Oracle.
oracle tutorial for beginners
sql convert
This Oracle tutorial video will show how to use conversion function in sql oracle
TO_CHAR() , TO_DATE() , TO_NUMBER() these are mostly used functions.
Conversions functions are used to convert one data type to another type.
1)To_CHAR ( number | date, [fmt], [nlsparams] )
The TO_CHAR function converts the number or date to VARCHAR2 data type in the specified
format (fmt).
2)TO_NUMBER( char, [‘fmt’] )
The TO_NUMBER function converts the characters to a number format.
3)TO_DATE( char, [‘fmt’] )
The TO_DATE function converts the characters to a date data type.
— TO_CHAR() fmYYYY YYYY/MM/DD
SELECT TO_CHAR(SYSDATE, ‘YYYY/MM/DD’) FROM DUAL; — SO USING TO_CHAR U CAN GET FORMATE OF DATE ACCORDING TO UR REQURMENTS
—- $99,999 99.99 99,00
SELECT TO_CHAR(487, ‘$99,0’) FROM DUAL; — U CAN GET DATA IN CURRENCY FORMAT
—- TO_NUMBER()
SELECT TO_NUMBER(‘1745′,’99999’) FROM DUAL;
SELECT TO_NUMBER(‘1,47,982′,’9,99,999′) FROM DUAL;
—- TO_DATE() — THIS CONVERT VARCHAR DATE TO PROPER DATE FORMAT
SELECT TO_DATE(’30-JAN-1995′,’DD-MON-RRRR’) FROM DUAL;
For more tutorial please visit #techquerypond
https://techquerypond.com
https://techquerypond.wordpress.com
https://twitter.com/techquerypond

Views: 3661
Tech Query Pond

https://www.databasestar.com/oracle-remainder-mod/
The Oracle MOD function performs a “modulo division” on the numbers you specify. A modulo division is where a division is performed using two numbers, and the remainder is returned by the function.
For example, the division of 8/5 is 1.6. Using modulo division, 8/5 will work out there is one 5 contained in the 8, with 3 left over. The MOD function would return 3 in this example.
The syntax of the MOD function is:
MOD(numerator, denominator)
The numerator is the number mentioned first in the division, or the one that is on top of the division sign. In a division such as 15/4, this would be the 15.
The denominator is the number mentioned second in the devision, or hte one that is on the bottom of the division sign. In a division such as 15/4, this would be the 4.
The parameters can be any numeric data type, and the return type depends on these parameters. This means MOD can return a whole number or a decimal number.
The calculation for the Oracle MOD function is: numerator - denominator * FLOOR(numerator / denominator).
If the denominator is 0, the function returns the value of the numerator. This is done to prevent “divide by 0” errors.
For more information about the MOD function, including how to return every second row, how it’s different to REMAINDER, and to see the SQL code used in these examples, read the related article here:
https://www.databasestar.com/oracle-remainder-mod/

Views: 809
Database Star

The DECIMAL data type is similar to the INT data type in that when you use the number for math, it maintains precision. The difference though is obvious in the name. The DECIMAL data type allows for numbers after a decimal point (and before the decimal point). The DECIMAL data type allows us to store what is known as a fixed-point number. A fixed point number is a number that has a specific number of digits available to store numbers in. That means we can't do things like use a DECIMAL data type to store as many digits of PI as possible, because we can't store unlimited digits. We are limited to a certain number.
There are two keywords you need to understand when you are working with the DECIMAL data type, precision and scale. Precision is the number of digits and scale is the number of those digits that will come after the radix. You are going to want to provide these numbers when you declare a column of this data type.
For example, DECIMAL(5, 2) has a precision of 5 digits and a scale of 2 digits. That means we can store a maximum of two digits after the decimal and four digits total. This gives us a possible range from -999.99 to 999.99
The highest number of digits is 65, and the highest number of digits after the decimal is 30.
This data type is also known as DEC, NUMERIC, and FIXED.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Support me! http://www.patreon.com/calebcurry
Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter
Donate!: http://bit.ly/DonateCTVM2.
~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~
More content: http://CalebCurry.com
Facebook: http://www.facebook.com/CalebTheVideoMaker
Google+: https://plus.google.com/+CalebTheVideoMaker2
Twitter: http://twitter.com/calebCurry
Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)

Views: 6343
Caleb Curry

Note: After Re-Branding 9Lean is now CodesBay
--------------------------------------------------------------------------------
The video is first pn the series of learning SQL using MySQL. This video describe the various numric data types as which can be used while creating the SQL Tables.
1. Numeric Types
2. Floating point types
3. Bit Fields
4. SQL Strict Mode
Hope it helps you in learning something new.. enjoy!
Please take a moment to Like! Subscribe! Share! and Comment! Your actions will keep me going
Want to get more, Connect me @
Youtube: https://www.youtube.com/CodesBay
Twitter: https://twitter.com/CodesBay
Facebook: https://www.facebook.com/CodesBay
instagram: https://www.instagram.com/CodesBay
Github: https://github.com/CodesBay
Pinterest: https://in.pinterest.com/CodesBay
Tumblr: https://CodesBay.tumblr.com
Web: http://www.CodesBay.com
#sql #databse #rdbms #mysql #tables

Views: 85
CodesBay

13-Oracle Database - Data Type Conversion Explicit and Implicit - To_Number - To_Char - To_Date.avi

Views: 2965
Adel Sabour

https://www.databasestar.com/oracle-nvl-nvl2-logical-functions/
The Oracle NVL function allows you to check a value and return a different value if that value is NULL.
It’s great for using another value if the first one is NULL or an optional value, for example people’s phone numbers.
It’s also good alongside aggregate functions and grouping so you can see what the difference is between a subtotal row and an actual NULL value.
The syntax of the Oracle NVL function is:
NVL( check_value, replace_value )
The parameters are:
- check_value (mandatory): This is the value that is displayed to the user. It is also the value that is checked for NULL.
- replace_value (mandatory): This is the value that appears if the check_value is NULL.
The function can use many different data types as parameters: string, date, or numeric. However, both parameters need to be the same type.
For more information about the Oracle NVL function, including all of the SQL shown in this video and the examples, read the related article here:
https://www.databasestar.com/oracle-nvl-nvl2-logical-functions/

Views: 136
Database Star

Explains the exact numeric data type INT or INTEGER. From http://ComputerBasedTrainingInc.com SQL Course. Learn by doing SQL commands for ANSI Standard SQL, Access, DB2, MySQL, Oracle, PostgreSQL, and SQL Server.

Views: 849
cbtinc

Please Subscribe Channel
Like, Share and Comment
Visit : www.geekyshows.com

Views: 29553
Geeky Shows

Oracle - SQL - Number Functions
Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm
Lecture By: Mr. Anadi Sharma, Tutorials Point India Private Limited.

Views: 2122
Tutorials Point (India) Pvt. Ltd.

Please Subscribe Channel
Like, Share and Comment
Visit : www.geekyshows.com

Views: 24044
Geeky Shows

Join discussion on: http://www.techtud.com/video-lecture/introduction-sql
IMPORTANT LINKS:
1) Official Website: http://www.techtud.com/
2) Virtual GATE: http://virtualgate.in/login/index.php
Both of the above mentioned platforms are COMPLETELY FREE, so feel free to Explore, Learn, Practice & Share!
Our Social Media Links:
Facebook Page: https://www.facebook.com/techtuduniversity
Facebook Group: https://www.facebook.com/groups/virtualgate
Google+ Page: https://plus.google.com/+techtud/posts
Last but not the least, SUBSCRIBE our YouTube channel to stay updated about the regularly uploaded new videos.

Views: 12311
Techtud

FLOAT and DOUBLE data types are data types that can be used to store numbers that can include decimal numbers. They are specifically used to store estimates. What do I mean? I mean that the precision of a FLOAT or DOUBLE value can be lost when doing math. The data types are only capable of maintaining a certain level of precision. The level of precision is usually adequate for most mathematical operations. If you need to store exact data, you will want to look into using the INT or DECIMAL data type instead.
The numbers stored in a FLOAT or DOUBLE column are called floating point numbers, we'll see why in just a moment.
Why are they called floating point numbers? let's look at a number. 150. This number could be represented as 150, or it could be represented as 1.5 * 10^2, or 1.5e2. With floating point numbers, scientific notation is used. These numbers are called floating point numbers because the decimal can float to different spots as we change the exponent.
This means that the data type needs to store the number, how many decimal the number needs moved, and a sign bit.
The benefit of floating point numbers is that they allow us to store pretty huge numbers. The down side is that they are not storing values exactly because they are limited in size. This means that only a certain level of precision is to be expected from a floating point data type.
If you remember from the video of DECIMAL, precision is the number of digits in a number. As long as the precision for one of these data types exceeds the need for your specific data, the data type can work fine. For example, if you are storing a number like 15 trillion, you don't have to worry as much with precision as your number does not contain a lot of digits. This number can be represented as 1.5 x 10^13. This is a lot different than trying to store 1.5534534534 x10^13.
Now we know both of these data types do not maintain a high number of digits correctly, but what is the difference between FLOAT and DOUBLE. The difference is the amount of storage they take up. Float takes up 4 bytes while DOUBLE takes up 8. The benefit in DOUBLE is that because it has more room to store data, it has a higher level of precision and can store bigger numbers.
Now, what level of precision can you expect from either of these? FLOAT around 7 and DOUBLE around 15. Now, these data types are obnoxious because the exact values depend on your operating system and in general these monsters cannot be trusted. Especially when you start doing math with different numbers. In general, it is recommended to use the DOUBLE data type to have a higher level of precision and calculations in MySQL are done with DOUBLE.
Always remember… prepare for trouble, make it double.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Support me! http://www.patreon.com/calebcurry
Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter
Donate!: http://bit.ly/DonateCTVM2.
~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~
More content: http://CalebCurry.com
Facebook: http://www.facebook.com/CalebTheVideoMaker
Google+: https://plus.google.com/+CalebTheVideoMaker2
Twitter: http://twitter.com/calebCurry
Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)

Views: 6660
Caleb Curry

Explains the approximate numeric data type DOUBLE PRECISION. From http://ComputerBasedTrainingInc.com SQL Course. Learn by doing SQL commands for ANSI Standard SQL, Access, DB2, MySQL, Oracle, PostgreSQL, and SQL Server.

Views: 637
cbtinc

This video tutorial explains the difference between similar looking and used char datatype and varchar2 datatypes with an simple example. This video will answer the question such as how is the data internally stored differently for char and vacchar2 datatype. Also why is varchar2 much better option to be used than char data type is explained.
If you want more such videos of exciting and amazing 'difference between' concepts, check out the links below :
union and union all : https://youtu.be/n9FqQOd8liY
replace and translate : https://youtu.be/HKYF77BGzOE
procedure and function : https://youtu.be/q3LmOenL120
in and exists : https://youtu.be/REX4IjRYlFw
rank and dense_rank : https://youtu.be/WGSX998hZ9M
delete and truncate : https://youtu.be/u76wMm2byXo
%type and %rowtype : https://youtu.be/MlLUFeZ_3eM

Views: 2751
Kishan Mashru

This video is part of LearnItFirst's SQL Server 2012: A Comprehensive Introduction course. More information on this video and course is available here:
http://www.learnitfirst.com/Course170
In this second of three videos about data types, Scott will discuss the two categories of numeric data types as well as examples of when to use certain data types.
Highlights from this video:
- What are the two categories of numeric data types and when are each used?
- Why is it important to choose the right numeric type?
- What must you be concerned with when storing numbers with decimals?
- The different integer-based numerics
- When is it appropriate to use money and smallmoney data types for currency?
and much more...

Views: 7469
LearnItFirst.com

Explains the exact numeric data type DEC, DECIMAL or NUMERIC. From http://ComputerBasedTrainingInc.com SQL Course. Learn by doing SQL commands for ANSI Standard SQL, Access, DB2, MySQL, Oracle, PostgreSQL, and SQL Server.

Views: 1815
cbtinc

In this video I use the COUNT and SUM functions available to the SQL language. I used the COUNT function to add up the number of records in my query. This function works well with all data types and will just count the number or records that result from the conditions of your query. The SUM function will add up the numeric values and produce a total amount of a column. When using a function be sure to use parenthesis around the column you are performing the function on. This video is part of a series of videos with the purpose of learning the SQL language. For more information visit Lecture Snippets at http://lecturesnippets.com.

Views: 7601
Lecture Snippets

link of SQL substr blog :
http://www.rebellionrider.com/SQL-substr-function.htm
SQL substr function
SQL Substr function will return a sub string of a specified length from the source string beginning at a given position.
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 the name suggests SQL Substr function will return substring from a given source string.
Let's see the Syntax
Substr (source_string, start_pos, Substr_length)
As we can see SQL substr function takes 3 parameters. First one is Source string from which you want to extract the segment.
Second parameter is Starting position for sub string from the Source string.
And the third parameter is Substr_length which is the length for the substring.
First two parameters are mandatory to specify while third one is optional.
So we can say.
SQL Substr function will return a sub string of a specified length from the source string beginning at a given position.
First parameter source string can be of any data type CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB whereas both start_pos, Substr_length parameters must be number data type.
The returning result of SQL Substr function is of same data type of source string.
Let's see an example of SQL Substr function.
SELECT substr('www.RebellionRider.com',5,14) FROM dual;
Here in this query url of my website www.RebellionRider.com is our source string with the total length of 22 characters,
Now, I want to extract the name of my website that is, RebellionRider. So if you count the total length of the name of the website, it is 14.
That's why I have specified 14 as my third parameter of SQL Substr function which is substr_length.
Also the name of the website RebellionRider is starting from 5th position therefore I have specified 5 at second parameter of SQL substr function which is strt_pos or starting position.
Execute it.
Here is our result RebellionRider
When starting position is larger than the length of source string.
In this case SQL Substr function will return NULL as a result.
Let's do an example.
SELECT substr('www.RebellionRider.com',23,14) FROM dual;
As you can see here I have specified 23 at starting position and the total length of our source string is 22 characters
Let's execute
And the result is Null.
Second scenario
When the Substr_length is greater than source string
In this case the segment return is the substring from starting position to the end of the string.
For example
SELECT substr('www.RebellionRider.com',5,23) FROM dual;
Our starting position is at 5 means at the first R of RebellionRider and length of substring is set to 23 which is greater than the length of source string that is 22.
Execute.
As you can see we get a substring from first R of RebellionRider till the end of the source String.
Third scenario
When you supply numeric or arithmetic expression or a DATE instead of character as Source string to SQL Substr function
In this scenario
If you have supplied a numeric string instead of character as source string, the oracle engine casts them as a character when they occur as parameter to SQL Substr function.
And if you have supplied Arithmetic expression or a DATE then
The Oracle engine first solves or evaluates the Arithmetic expression or the DATE
Then casts them as a character.
Means if you have arithmetic expression in your source string then oracle will first solve it and then change or say cast the value of its result into character.
Let's see some example.
SELECT substr(50000-7,2,4) FROM dual;
Oracle first evaluates the arithmetic expression that is
50000-7 equals to 49993. And then oracle engine casts this result 49993 into a character string. Means 49993 will be a 5 characters string.
Starting position of substring is 2, that means from the first 9 of 49993
We specified the length of substring is 4 so we must get 9993 as our result.
Let's check execute

Views: 77898
Manish Sharma

DURGASOFT is INDIA's No.1 Software Training Center offers
online training on various technologies like JAVA, .NET ,
ANDROID,HADOOP,TESTING TOOLS , ADF, INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP...
courses from Hyderabad & Bangalore -India with Real Time Experts.
Mail us your requirements to [email protected]
so that our Supporting Team will arrange Demo Sessions.
Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696.
http://durgasoft.com
http://durgasoftonlinetraining.com
https://www.facebook.com/durgasoftware
http://durgajobs.com
https://www.facebook.com/durgajobsinfo............

Views: 838
Durga Software Solutions

Please Subscribe Channel
Like, Share and Comment
Visit : www.geekyshows.com

Views: 6272
Geeky Shows

This video is the 4th video in the series of 'working with null', this video explains the working of the coalesce function in oracle sql. Also the video explains the use of coalesce function in oracle sql queries by perfect simple and easy to understand examples.
COALESCE returns the first non-null expr in the expression list. You must specify at least two expressions. If all occurrences of expr evaluate to null, then the function returns null.
Oracle Database uses short-circuit evaluation. The database evaluates each expr value and determines whether it is NULL, rather than evaluating all of the expr values before determining whether any of them is NULL.
If all occurrences of expr are numeric datatype or any non numeric datatype that can be implicitly converted to a numeric datatype, then Oracle Database determines the argument with the highest numeric precedence, implicitly converts the remaining arguments to that datatype, and returns that datatype.

Views: 930
Kishan Mashru

Please Subscribe Channel
Like, Share and Comment
Visit : www.geekyshows.com

Views: 24072
Geeky Shows

Explains the exact numeric data type SMALLINT. From http://ComputerBasedTrainingInc.com SQL Course. Learn by doing SQL commands for ANSI Standard SQL, Access, DB2, MySQL, Oracle, PostgreSQL, and SQL Server.

Views: 437
cbtinc

In this video we will learn how to get decimal/float output from Integer division in SQL Server.
I am creating this video to answer once of the question that I posted while back for TSQL Interview Question list
"If I run Select 100/11 what output will I get?"
When you divide Integer by an Integer in SQL Server, SQL Server returns Integer output.
As we can see from our above example, SQL Server output is Integer for Integers division. If we want to get float or Decimal output, Either our denominator or Numerator should be float or decimal type.
If we have both denominator or numerator as Integers, we can use convert or cast functions to convert one of them to float/decimal so we can get our results as float/decimal.
There are multiple techniques you can use to convert/cast to integer to float/decimal, here are some examples
SELECT CAST(100 AS FLOAT) /11 AS OutputResult
SELECT 100/CAST(11 AS FLOAT) AS OutputResult
SELECT 100/CAST(11 AS DECIMAL(12,0)) AS OutputResult
SELECT CAST(100 AS DECIMAL(12,0))/11 AS OutputResult
Blog post link with scripts used in the video
http://sqlage.blogspot.com/2015/02/how-to-get-decimail-output-from.html

Views: 10563
TechBrothersIT

https://www.databasestar.com/oracle-to_date/
The Oracle TO_DATE function is one of the most useful conversion functions in Oracle. It can be a little confusing though.
The TO_DATE function is used to convert a character value to a date value.
You can use it to convert a string that is in the format of a date, into a date data type.
Why would you use this?
Converting a character to a date is helpful if you want to insert a date into a column in a table. Being specific about the format (explicit) is better than assuming the conversion will be done for you (implicit).
This TO_DATE function only converts to a DATE data type. If you want to convert to the other datetime data types, you’ll have to use other functions such as TO_TIMESTAMP or TO_TIMESTAMP_TZ.
The syntax for this function is:
TO_DATE(charvalue [, format_mask [, nls_date_language]])
The parameters for this function are:
Charvalue: This is the character value that you want to convert to a date. It’s the main input of the function.
Format_mask: This is the format that the input value, the charvalue, is in. This is used to help convert your character value into a date, as your character may be in a different format to the default.
Nls_date_language: this is used to determine how the output is displayed.
For more information about the Oracle TO_DATE function, including all of the SQL shown in this video and the examples, read the related article here:
https://www.databasestar.com/oracle-to_date/

Views: 678
Database Star

Donate!: http://bit.ly/DonateCTVM2. Videos Available for Download - http://www.udemy.com/calebthevideomaker2-database-and-mysql-classes/
Playlist - http://www.youtube.com/watch?v=krx-w9icrkU&list=PL405B31DD586979DE
Manual:
Decimal: http://dev.mysql.com/doc/refman/5.6/en/fixed-point-types.html
floating point: http://dev.mysql.com/doc/refman/5.6/en/floating-point-types.html
Decimal(M, D)
precision is how many digits are in the number, and scale is how many digits after the decimal.
defaults are 65 and 35
decimals are accurate up to about 7 digits.
doubles are accurate up to about 15 digits.
More content: http://CalebCurry.com
Facebook: http://www.facebook.com/CalebTheVideoMaker
Google+: https://plus.google.com/+CalebTheVideoMaker2
Twitter: http://Twitter.com/calebCurry
Subscribe (it's free!): http://bit.ly/PqPyvH
Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)

Views: 4075
Caleb Curry

Pebbles present, Learn Oracle 10g with Step By Step Video Tutorials.
Learn Oracle 10g Tutorial series contains the following videos :
Learn Oracle - History of Oracle
Learn Oracle - What is Oracle - Why do we need Oracle
Learn Oracle - What is a Database
Learn Oracle - What is Grid Computing
Learn Oracle - What is Normalization
Learn Oracle - What is ORDBMS
Learn Oracle - What is RDBMS
Learn Oracle - Alias Names, Concatenation, Distinct Keyword
Learn Oracle - Controlling and Managing User Access (Data Control Language)
Learn Oracle - Introduction to SQL
Learn Oracle - Oracle 10g New Data Types
Learn Oracle - How to Alter a Table using SQL
Learn Oracle - How to Create a Package in PL SQL
Learn Oracle - How to Create a Report in SQL Plus
Learn Oracle - How to Create a Table using SQL - Not Null, Unique Key, Primary Key
Learn Oracle - How to Create a Table using SQL
Learn Oracle - How to Create a Trigger in PL SQL
Learn Oracle - How to Delete Data from a Table using SQL
Learn Oracle - How to Drop and Truncate a Table using SQL
Learn Oracle - How to Insert Data in a Table using SQL
Learn Oracle - How to open ISQL Plus for the first time
Learn Oracle - How to Open SQL Plus for the First Time
Learn Oracle - How to Update a Table using SQL
Learn Oracle - How to use Aggregate Functions in SQL
Learn Oracle - How to use Functions in PL SQL
Learn Oracle - How to use Group By, Having Clause in SQL
Learn Oracle - How to Use Joins, Cross Join, Cartesian Product in SQL
Learn Oracle - How to use Outer Joins (Left, Right, Full) in SQL
Learn Oracle - How to use the Character Functions, Date Functions in SQL
Learn Oracle - How to use the Merge Statement in SQL
Learn Oracle - How to use the ORDER BY Clause with the Select Statement
Learn Oracle - How to use the SELECT Statement
Learn Oracle - How to use the Transactional Control Statements in SQL
Learn Oracle - How to use PL SQL
Learn Oracle - Data Types in PL SQL
Learn Oracle - Exception Handling in PL SQL
Learn Oracle - PL SQL Conditional Logics
Learn Oracle - PL SQL Cursor Types - Explicit Cursor, Implicit Cursor
Learn Oracle - PL SQL Loops
Learn Oracle - Procedure Creation in PL SQL
Learn Oracle - Select Statement with WHERE Cause
Learn Oracle - SQL Operators and their Precedence
Learn Oracle - Using Case Function, Decode Function in SQL
Learn Oracle - Using Logical Operators in the WHERE Clause of the Select Statement
Learn Oracle - Using Rollup Function, Cube Function
Learn Oracle - Using Set Operators in SQL
Learn Oracle - What are the Different SQL Data Types
Learn Oracle - What are the different types of Databases
Visit Pebbles Official Website - http://www.pebbles.in
Subscribe to our Channel – https://www.youtube.com/channel/UCNNjWVsQqaMYccY044vtHJw?sub_confirmation=1
Engage with us on Facebook at https://www.facebook.com/PebblesChennai
Please Like, Share, Comment & Subscribe

Views: 2006
Pebbles Tutorials

Explains exact numeric data types with a comparison of usage by the major databases. From http://ComputerBasedTrainingInc.com SQL Course. Learn by doing SQL commands for ANSI Standard SQL, Access, DB2, MySQL, Oracle, PostgreSQL, and SQL Server.

Views: 260
cbtinc

تحديد انواع البيانات في قواعد البيانات مع شرح لبعضها مثل ال
Char,varchar,BOOL,TEXT,float, double ,INT
و شرح لبعض الخصائص التي تأتي معها مثل
long,tiny , small,meduime
رابط تحميل الدرس
http://abdullaheid.org/download/mysql101/36.Data-Types.zip

Views: 14194
Abdullah Almehmadi

https://www.databasestar.com/oracle-ceil/
The Oracle FLOOR function will return the largest integer value less than the specified number. In other words, it rounds down to the nearest whole number.
It’s the opposite of the CEIL function, which rounds up.
The syntax of FLOOR is:
FLOOR(number)
The number parameter can be any numeric data type. The function will return a number in the same data type as the parameter.
So, you can use FLOOR with decimal numbers, which is actually where FLOOR works best. You can use it with whole numbers too. It won’t show an error, it just might display the same value as provided (e.g. FLOOR(5) would be 5).
You can also use functions inside FLOOR. For example, FLOOR(SUM(salary)) will SUM all of the salary values, and then round them down to the nearest whole number.
Just like with all functions, the Oracle FLOOR function can also use column aliases. So, instead of having your column labelled “FLOOR(8.12)” or “FLOOR(salary)”, you can label your column “salary_rounded” or something that makes more sense.
The FLOOR function is similar to the ROUND function. However, ROUND will round up or down, where FLOOR will always round down. The TRUNC function will also do some kind of rounding, but it removes decimals from a number which may cause it to “round” down.
For more information, including the code used in the examples, read the related article here:
https://www.databasestar.com/oracle-ceil/

Views: 411
Database Star

تعلم اوراكل حتى الاحتراف
تعلم اوراكل من الصفر

Views: 3117
khaled alkhudari

Welcome to techtalktricks and in this video, we will learn different -
different data type of pl/sql.So stay tuned and watch data type of pl/sql like scalar data type(Numeric,boolean,char etc)
#TechTalkTricks #RanaSingh
SUBSCRIBE our channel at :
https://www.youtube.com/techtalktricks
**************************************************
Follow Tech Talk Trick on Facebook
https://www.facebook.com/techtalktricks
**************************************************
Follow tech talk trick on Twitter
https://twitter.com/tecktalktrick
**************************************************
Follow Tech Talk Tricks on Instagram
https://www.instagram.com/techtalktricks
**************************************************
Subscribe tech talk tricks on YouTube
https://www.youtube.com/techtalktricks
***************************************************
Channel tag :
techtalktricks,
tech
talk
tricks
html,
css,
java,
sql,
computer tricks,

Views: 320
Tech Talk Tricks

REPLACE function replaces a sequence of characters in a string with another set of characters or Numeric Functions - Ceil, Floor, Round, mod, replace, power or How to use REPLACE function in SQL or what are the numeric function oracle SQL database
Assignment link will be available soon:
SQL basics, create table oracle, SQL functions, SQL queries, SQL server, SQL developer installation, Oracle database installation, SQL Statement, OCA, Data Types, Types of data types, SQL Logical Operator, SQL Function,Join- Inner Join, Outer join, right outer join, left outer join, full outer join, self-join, cross join, View, SubQuery, Set Operator.
follow me on:
Facebook Page:
https://www.facebook.com/LrnWthr-319371861902642/?ref=bookmarks
Contacts Email:
[email protected]
Instagram:
https://www.instagram.com/equalconnect/
Twitter:
https://twitter.com/LrnWthR

Views: 18
EqualConnect Coach

Explains the exact numeric data type BIGINT. From http://ComputerBasedTrainingInc.com SQL Course. Learn by doing SQL commands for ANSI Standard SQL, Access, DB2, MySQL, Oracle, PostgreSQL, and SQL Server.

Views: 524
cbtinc

Explains the approximate numeric data type FLOAT. From http://ComputerBasedTrainingInc.com SQL Course. Learn by doing SQL commands for ANSI Standard SQL, Access, DB2, MySQL, Oracle, PostgreSQL, and SQL Server.

Views: 884
cbtinc