Working with LOBs
Views: 8879
Naresh i Technologies
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: 99898
The Bad Tutorials
https://www.databasestar.com/oracle-to_char/
The Oracle TO_CHAR function is a common and useful string manipulation function. It allows you to convert a number or a date value into a string value.
It allows you to take a number or a string, and convert it to a VARCHAR2 data type.
The syntax of the function is:
TO_CHAR( input_value, [format_mask], [nls_parameter] )
The parameters are:
- input_value: this is the value to convert to a VARCHAR2 value. It can be one of many different number or date data types.
- format_mask is an optional parameter and allows you to specify the format to display the output as. If this is omitted, the function uses a default format.
- nls_parameter: this is also optional and lets you determine a regional parameter for displaying the output value.
The format mask helps you determine what your output is displayed as. For example, if you provide the date of May 3rd, and the output is ‘03/05/2018’, how do you know if this is May 3rd or March 5th? Using a format mask can specify which format is used.
The function is similar to the TO_NUMBER and TO_DATE functions, in that they both convert a specific data type.
For more information about the Oracle TO_CHAR function, including all of the SQL shown in this video and the examples, read the related article here:
https://www.databasestar.com/oracle-to_char/
Views: 987
Database Star
This video we are going to discuss the VARCHAR2 and the NVARCHAR2 data types.
The previous videos are a good foundation to this video. I've actually discussed so much stuff in those videos that I don’t have a whole lot to say. Good for you, right?
I discussed over the previous videos that you should prefer to use VARCHAR2 over CHAR. That's because there is not a difference in performance or storage for a VARCHAR2 column. The only difference is that an CHAR column forces each value to take up a certain length even if it's not.
There is one difference between the variable length and fixed length data types here that you need to know about, and that is storage limits. CHAR has a limit of 2000 bytes, while VARCHAR2 has a limit of 4000 bytes. That means you can store twice as much junk in a VARCHAR2 column!
Other than that, these data types work exactly the same. I recommend you always use the VARCHAR2 data types instead of the CHAR data types, and only use NVARCHAR2 if you have a non-Unicode database. This will allow you to store Unicode characters in a column.
Now, the amount of storage you can put in a VARCHAR2 column is twice what you can put in a CHAR column, but 4000 characters is still not very many characters. This is where the LOB data types come in, which we will discuss in the next video!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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: 5449
Caleb Curry
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: 7994
Caleb Curry
Servlet based web application for BLOB and CLOB using java, tomcat, oracle xe.
create table link: https://github.com/pratikthakkar/dbms
join our community at: https://discord.gg/4M5dr3E
Views: 4055
pratik thakkar
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:
Binary and Varbinary:
http://dev.mysql.com/doc/refman/5.6/en/binary-varbinary.html
blobs:
http://dev.mysql.com/doc/refman/5.6/en/blob.html
binary is similar to char
varbinary is similar to varchar
binary is a byte string rather than a character string
no character set!
blob is commonly used for encryption.
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: 5697
Caleb Curry
How to load text content into oracle table CLOB column?
http://easy-learning-tech.blogspot.in/2018/04/loading-clob-data-into-oracle-table.html
Views: 1078
Siva Academy
Converting Character Large Object of Source to Binary Large Object of Target using Informatica Java Transformation.
For more information please check http://gogates.blogspot.in/2013/09/transfering-clob-data-to-blob-using.html
Views: 5527
Mandar Gogate
NCHAR is another data type available in Oracle database. This data type is very similar to the char data type with some key differences. NCHAR is also known as the national character set. This is a data type that allows us to store Unicode characters.
It is really recommended that you watch the two videos over Unicode and UTF-8 because this video is going to talk a lot about it. Why is it that we have an entire data type dedicated to storing Unicode? That will be easily understood once we understand how character sets and encodings are applied to Oracle. They are applied at the database level. That means that you have a character set that applies to the entire database. This is in contrast to some database management systems that allow you to apply a data type at the table and column level. For example, in MySQL you can make a table have a character set, and make a specific column in that table a different character set. That means we can customize everything at the expense of adding potential complexity and confusion. Oracle does not work that way. In Oracle, we define one character set for the entire database.
The problem with defining a character set for the entire database is that it may not be the character set we want to use for everything. That is where the NCHAR column comes in. The NCHAR column allows us to have a Unicode column inside of a database that does not use Unicode as the default character set. That is important because it is very often that we want to use Unicode but we may not need to use it for everything, for example if that application is working with ASCII nearly all of the time.
If you are using Unicode for the database, then NCHAR is not going to be needed and should not be used. This data type is not as widely accepted, so only use it if you absolutely need to, specifically when you need to store Unicode in a non-Unicode database. Additionally, there is some controversy when it comes to whether or not you should use the CHAR and NCHAR data types in Oracle at all. We will discuss why in an upcoming video.
In the next video we are going to go over some specific character sets that Oracle can use. See you then!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Suppor 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: 4070
Caleb Curry
SQL CONVERT function converts an expression from one datatype to another datatype.
visit Dose for excel Add-In website:
http://www.zbrainsoft.com/
Visit our channel:
https://www.youtube.com/channel/UCI4bMWYzrBTs47KINXL92Kw
Views: 169
Super Collection Studio
Servlet based web application for BLOB and CLOB using java, tomcat, oracle xe.
create table link: https://github.com/pratikthakkar/dbms
join our community at: https://discord.gg/4M5dr3E
Views: 648
pratik thakkar
** For Online Training Registration: https://goo.gl/r6kJbB ? Call: +91-8179191999
💡 Visit Our Website for Classroom Training:
https://nareshit.in/sql-server-training/
💡 For Online Training:
https://nareshit.com/course/sql-server-online-training/
#sqlserver #server #programming #course #Tutorials #Training #Videos
--------------------------
💡 About NareshIT:
"Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, Data Science, Python, Tableau, RPA , Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in USA, Hyderabad, Chennai and Vijayawada, Bangalore India which provides online training across all the locations
--------------------------
💡 Our Online Training Features:
🎈 Training with Real-Time Experts
🎈 Industry Specific Scenario’s
🎈 Flexible Timings
🎈 Soft Copy of Material
🎈 Share Videos of each and every session.
--------------------------
💡 Please write back to us at
📧 [email protected]/ 📧 [email protected] or Call us at the USA: ☎+1404-232-9879 or India: ☎ +918179191999
--------------------------
💡 Check The Below Links
► For Course Reg: https://goo.gl/r6kJbB
► Subscribe to Our Channel: https://goo.gl/q9ozyG
► Circle us on G+: https://plus.google.com/+NareshIT
► Like us on Facebook: https://www.facebook.com/NareshIT
► Follow us on Twitter: https://twitter.com/nareshitek
► Follow us on Linkedin: https://goo.gl/CRBZ5F
► Follow us on Instagram: https://goo.gl/3UXYK3
Views: 17272
Naresh i Technologies
The difference between different types of character datatypes
CHAR
VARCHAR
VARCHAR2
NVARCHAR
Views: 3474
Rishabh Jain
How to add text before value in Oracle SQL
Views: 83
Tanmun
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: 3173
Kishan Mashru
BELOW CODE
cerate report server below commands
windows key+R
run paste -- rwserver server=showjobs status=on
Declare
repid REPORT_OBJECT;
v_rep VARCHAR2(1000);
rep_status VARCHAR2(20);
PL_ID PARAMLIST;
pr_nm varchar2(20):='PNM';
--rwserver server=SHOWJOBS EXCECUTE IT ON RUN
v_rptserver varchar2(10):='SHOWJOBS'; ---- Change 1
v_host varchar2(20):='localhost'; ---- Change 2
-- v_rptserver varchar2(10):=:global.RWS1;
-- v_host varchar2(20):=:global.IP1;
BEGIN
PL_ID := GET_PARAMETER_LIST(pr_nm);
IF ID_NULL(PL_ID) = FALSE THEN
DESTROY_PARAMETER_LIST(PL_ID);
PL_ID := CREATE_PARAMETER_LIST(pr_nm);
IF ID_NULL(PL_ID) THEN
MESSAGE('ERROR CREATING PARAMETER LIST '||pr_nm);
RAISE FORM_TRIGGER_FAILURE;
END IF;
ELSE PL_ID := CREATE_PARAMETER_LIST(pr_nm);
END IF;
--add parameter with separate statement for each parameter
Add_Parameter(pl_id,'P_ECode',TEXT_PARAMETER,:P_ECode); ---change 3 your report have parameters
Add_Parameter(pl_id,'P_ECode',TEXT_PARAMETER,:P_ECode);
repid := find_report_object('DESG'); --- change 4 report name
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_EXECUTION_MODE,BATCH);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_COMM_MODE,SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESTYPE,CACHE);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT,'PDF'); -- change 5 pdf/html
-- SET_report_object_property(repid,REPORT_DESFORMAT,:BLOCK3.REP_FORMAT); ------ need all format
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_SERVER,v_rptserver);
v_rep := RUN_REPORT_OBJECT(repid,PL_ID);
rep_status := REPORT_OBJECT_STATUS(v_rep);
IF rep_status = 'FINISHED' THEN
WEB.SHOW_DOCUMENT('http://'||v_host||':8889/reports/rwservlet/getjobid' ||substr(v_rep,instr(v_rep,'_',-1)+1)||'?'||'server='||v_rptserver,'_blank');
ELSE
message('Error when running report');
END IF;
END;
Views: 5969
Together Oracle
Views: 499
Shri Ram Programming Academy
Detail explanation on oracle data type like Number blob/clob/nclob/(integer)/varchar2/varchar/char/nvarchr2/ncharvarchar2/date/long/rowid
Giving the in-depth explanation on the data type of Oracle database
--------------------------------------------------
Oracle SQL Practice Question:
There is no practice question for this topic
--------------------------------------------------
Frequently asked interview question on Oracle SQL
https://www.youtube.com/watch?v=f7E30fV8wJA&index=1&list=PLiLpmqwkwkCv4qmtBnz4M3zIs1_ukkboT
In this video, you will get the answer to the following question
what is Oracle data type
where to use Oracle data type
why we Oracle data type
oracle data types tutorial
In this series we cover the following topics:
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/lrnwthr/
Twitter:
https://twitter.com/LrnWthR
Views: 244
EqualConnect Coach
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: 148
Prabhat Sahu
This Video Shows
1. How to Read and parse XML in Oracle using EXTRACTVALUE and XMLTABLE. 2. When to use extractvalue and XMLTable.
3. Brief Introduction to XMLPATH
Views: 12202
yrrhelp
Save and Retrieve image from Database using C# and SQL Server. The C# Basics beginner course is a free C# Tutorial Series that helps beginning programmers learn the basics of the C# Programming Language. This is the best way to Learn C# for beginners
Views: 80359
Fox Learn
Batch import SQL Server [TEXT, NTEXT, VARCHAR(MAX), NVARCHAR(MAX)] (CLOB) data, by SqlLobEditor, http://www.withdata.com/sqllobeditor/ .
Download link: http://www.withdata.com/down/SqlLobEditor.exe .
Views: 990
Shiji Pan
Mapping to Read XML data from Oracle Clob and use XML parser to write it into XML files.
Views: 3822
InfaMarketplace
Oracle Datatypes
Difference between Char and Varchar
Date
Number
Views: 73
CodeSmith 001
Batch export Oracle CLOB data, by OraLobEditor, http://www.withdata.com/oralobeditor/ .
Download link: http://www.withdata.com/down/OraLobEditor.exe .
Views: 373
Shiji Pan
Please Subscribe Channel
Like, Share and Comment
Visit : www.geekyshows.com
Views: 30146
Geeky Shows
The first category of data types that we are going to cover in this MySQL series are the string data types, or character data types. There are two that I am going to talk about in this video, CHAR and VARCHAR. We'll start with CHAR.
CHAR is a string data type where you specify how many characters are allowed in parenthesis after you declare the column as this type.
For example, we can say CHAR(50) to allow up to 50 characters for each value in that column.
The thing to know about CHAR though is that it is a fixed-length string. That means every single value inside of that column is actually going to be whatever you declare the length as. So if you say CHAR(50), every string is going to be 50 characters long. If, for example, you have a row that only uses 40 characters, MySQL will pad the right side of the string with spaces until it fills 50 characters.
Now, the highest value you can put in here is 255. The 255 refers to characters. This means that you can have strings with up to 255 characters. How does the computer know how to store these characters? That has to deal with the character set and the encoding of the characters. By default, MySQL is going to use UTF-8. We are not going to discuss UTF-8 in detail for a while but essentially UTF-8 says that each character can take up to 3 bytes of storage.
255 comes from the max number you can count to using binary. So if we are keeping track of how many values are in this column in an 8 bit number, 255 is the highest. If you don't know what I'm talking about it, we'll worry about it later.
You can actually make the column CHAR(0). In this situation, the only thing you could put in as a value for this column is an empty string ('').
When retrieving variable length CHAR data from a database it may not look like the database pads the value. That's because MySQL actually strips spaces from the value when presented. If you want to keep all of the spaces that have been added when you retrieve the value, you can do that. Look up PAD_CHAR_TO_FULL_LENGTH online.
In the next video we are going to discuss VARCHAR.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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: 4638
Caleb Curry
The last section of videos covered the string data types, now we are going to move on to the numeric data types.
This video is going to discuss the INTEGER data types, or the INT data types. These data types are used to store whole numbers. That is, numbers without anything after a decimal.
Just like with the TEXT data type, INT is broken up into multiple data types that can be used. It is actually broken up into 5 different data types. TINYINT, SMALLINT, MEDIUMINT, INT, BIGINT.
Now, the confusing part here is the naming. That's because the only thing we have to compare this naming to is the TEXT data types. But they don't follow a consistent naming convention. For example, MEDIUMTEXT is larger than TEXT, but MEDIUMINT is smaller than INT. Additionally, there are 5 data types for the INT data type group, and lastly the biggest INT data type is called BIGINT whereas the biggest TEXT data type is called LONGTEXT.
These are used to store exact values. What that means is that if you store a number and use it, you expect it to maintain precision. There are data types that are used for estimated values which we are going to discuss in more detail in an upcoming video. For now, let's focus on INT data types.
You can find the exact storage limits for each of these, but here is some info:
TINYINT - 255
SMALLINT - 65535
MEDIUMINT - 16 Million
INT - 4 Billion
BIGINT - Stinkin' a lot (18446744073709551615)
Now note, in this situation, we will have to label each one of these as UNSIGNED. An unsigned number does not allow for negatives, but allows higher positive numbers. You can look up the INT data types to get the exact ranges for signed and unsigned.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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: 4084
Caleb Curry
Explains the data type BLOB or Binary Large Object. From http://ComputerBasedTrainingInc.com SQL Course. Learn by doing SQL commands for ANSI Standard SQL, Access, DB2, MySQL, Oracle, PostgreSQL, and SQL Server.
Views: 2393
cbtinc
Explains the SQL LONG VARCHAR data type. From http://ComputerBasedTrainingInc.com SQL Course. Learn by doing SQL commands for ANSI Standard SQL, Access, DB2, MySQL, Oracle, PostgreSQL, and SQL Server.
Views: 727
cbtinc
Batch export SQLite BLOB data from query results, by SqliteLobEditor, http://www.withdata.com/sqlitelobeditor/ .
Download link: http://www.withdata.com/down/SqliteLobEditor.exe .
Views: 288
Shiji Pan
Explains the SQL VARCHAR or variable length character data type. From http://ComputerBasedTrainingInc.com SQL Course. Learn by doing SQL commands for ANSI Standard SQL, Access, DB2, MySQL, Oracle, PostgreSQL, and SQL Server.
Views: 2188
cbtinc
Batch update SQL Server [IMAGE, VARBINARY(MAX)] (BLOB) field data, by SqlLobEditor, http://www.withdata.com/sqllobeditor/ .
Download link: http://www.withdata.com/down/SqlLobEditor.exe .
Views: 1822
Shiji Pan
Views: 1234
Sagar S
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
Welcome to your very first video in this series, MySQL Datatypes! Please subscribe and like my videos, it means a TON to me. Thanks :)
This is simply a small course to introduce you to all of the datatypes(excluding spatial, which I will not be covering in this course).
All of the datatypes are broken into 4 sections, these are Numeric, Date and Time, String, and Spatial. In all, these are the datatypes I will be covering: tinyint, smallint, mediumint, int, bigint, decimal, float, double, real, bit, boolean, serial, date, datetime, timestamp, time, year, char, varchar, tinytext, text, mediumtext, longtext, binary, varbinary, tinyblob, mediumblob, blob, longblob, enum, and set. Wooah that's a lot. haha.
I will not be going over geometry, point, linestring, polygon, multipoint, or multilinestring. If you want to learn more about Spatial types, start here: http://dev.mysql.com/doc/refman/5.6/en/mysql-spatial-datatypes.html
Want more information about what is covered in these videos? Always be sure to read the supporting page in the MySQL manual. http://dev.mysql.com/doc/refman/5.6/en/index.html
Video information: Char and Varchar
___________________________
Char has a character range from 0 up to 255, varchar allows up to 65535.
a max length can be specified in parenthesis such as char(40).
char is right padded to fit the specified amount of characters, and the spaces are then removed on retrieval. Only trailing spaces will be removed. for example. Cat_hat__ will come out as cat_hat. This can be a bad thing if you need to store spaces. you will need to use varchar instead.
If a value entered is too long, it will be "truncated," or cut to length.
Extra info
________
a character set is an allowed range of characters that are entered into an entry. such as UTF-8. Utf 8 is 3 bytes for every character.
the storing information for varchar and char are like this..
char - string length.
varchar - string length+1.
A 10 character entry using UTF-8 would then take 30 bytes in char, and 31 bytes in varchar, but if only 5 characters are entered, it will be 30 bytes for char, and 16 for varchar. This is because char stores the trailing spaces till the requested size is full (in this case 10).
A table maximum row size is 65535, so this means if you have a varchar 65535 that is completely full in one column, that is the max allowed stored across that column.
Any corrections needing made in these videos please message me. Thank you!
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: 14712
Caleb Curry
Batch import Oracle CLOB data, by OraLobEditor, http://www.withdata.com/oralobeditor/ .
Download link: http://www.withdata.com/down/OraLobEditor.exe .
Views: 760
Shiji Pan
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: 898
cbtinc
Batch import PostgreSQL TEXT (CLOB) data, by PGLobEditor, http://www.withdata.com/pglobeditor/ .
Download link: http://www.withdata.com/down/PGLobEditor.exe .
Views: 1998
Shiji Pan
Explains the Scalar Function CURRENT_USER, USER or who the user is. From http://ComputerBasedTrainingInc.com SQL Course. Learn by doing SQL commands for ANSI Standard SQL, Access, DB2, MySQL, Oracle, PostgreSQL, and SQL Server.
Views: 150
cbtinc
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: 4199
Caleb Curry
NEED TO LEARN JAVA? - 5 FREE JAVA VIDEO COURSES - CLICK HERE - https://goo.gl/7i95F8
---
View more videos on my "Java JDBC Tutorial" Playlist: http://goo.gl/crT4nS
Download Java Source Code: http://www.luv2code.com/?p=1095, Follow Me on Twitter: https://twitter.com/darbyluvs2code
Please SUBSCRIBE to this channel: https://www.youtube.com/user/luv2codetv?sub_confirmation=1
---
In this video tutorial we will learn how to use JDBC to read and write CLOB with MySQL.
---
Views: 24801
luv2code
Batch export SQL Server [TEXT, NTEXT, VARCHAR(MAX), NVARCHAR(MAX)] (CLOB) data, by SqlLobEditor, http://www.withdata.com/sqllobeditor/ .
Download link: http://www.withdata.com/down/SqlLobEditor.exe .
Views: 808
Shiji Pan
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: 538
cbtinc