Home
Search results “Decimal oracle format”
Oracle SQL Tutorial 33 - NUMBER Data Type
 
07:18
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: 6854 Caleb Curry
MySQL 31 - DECIMAL Data Type
 
02:20
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: 6323 Caleb Curry
Get Decimal/Float output from Integer Division in SQL Server - SQL Server Tutorial
 
02:47
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: 10548 TechBrothersIT
CONCATENATION OPERATOR, TO_CHAR CURRENCY, MONEY SYMBOL in oracle SQL
 
04:56
How to use concatenation operator, to_char, currency symbol, display money
Session6 Data type in Oracle
 
15:25
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 :)
Oracle CAST Function
 
03:23
https://www.databasestar.com/oracle-cast/ The Oracle CAST function allows you to convert one data type to another. It’s similar to the TO_NUMBER, TO_DATE, and TO_CHAR functions, but allows for more functionality, including converting to many other data types. The syntax of the CAST function is: CAST( {expr | MULTISET (subquery) } AS type_name ) The structure of this function is different to other functions, because it uses the word AS to separate parameters rather than a comma. You can run this function like many other functions, on a single row, which would look like this: CAST( expr AS type_name ) Or, you can run it as though it’s a subquery, using the MULTISET feature: CAST( MULTISET (subquery) AS type_name ) The parameters of the CAST function are: - expr (mandatory choice): This is the value or expression that is to be converted to another data type. - MULTISET (optional): This keyword indicates that the subquery results will return multiple rows, and are then CAST into a collection value. If this is omitted, and the subquery returns multiple rows, it will only return a single row. - subquery (mandatory choice): This is the subquery that can be run to be converted into a collection data type. - type_name (mandatory): This is the Oracle data type that the expr or subquery will be converted to. There are several data types that are compatible with the CAST function, both for converting from and to. You can find the full list in the article mentioned below. For more information about the Oracle CAST function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-cast/
Views: 1767 Database Star
Oracle MONTHS_BETWEEN Function
 
02:17
https://www.databasestar.com/oracle-months_between/ The Oracle MONTHS_BETWEEN function allows you to find the number of months between two dates. You can enter two dates and the function returns the difference. This function is often used as part of other calculations. Sometimes you’ll want to know the difference between two dates to perform other functions. The syntax of the MONTHS_BETWEEN function is: MONTHS_BETWEEN(date1, date2) What do these two parameters mean? The function performs date1 minus date2. So, if date1 is larger, the result is positive. If date2 is larger, then the result is negative. What data type is returned? It depends on the values you provide. If the dates are both on the same day of the month (e.g. both on the 10th of the month), then the result is an integer or whole number. If not, then the result will be a decimal value. For more information on the MONTHS_BETWEEN function, including the code used in this video and examples, read the related article here: https://www.databasestar.com/oracle-months_between/
Views: 782 Database Star
SQL Data Wrangling in Oracle:Table Data - What is CROSS APPLY?
 
02:32
This video clip, on CROSS APPLY, is taken from my www.pluralsight.com course "SQL Data Wrangling in Oracle:Table Data". Click here to learn more about this course: http://www.pluralsight.com/courses/sql-data-wrangling-oracle-tables?utm_source=youtube&utm_medium=video&utm_campaign=authordemo.
Views: 768 sheepsqueezersYT
Oracle MOD Function
 
03:17
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
7. MySQL: DECIMAL, NUMERIC, FLOAT, DOUBLE and REAL Data Types
 
08:37
In this video you'll be taught about the DECIMAL, NUMERIC, FLOAT, DOUBLE and REAL Data Types.
Views: 1223 Coding Senpai
MySQL Data Types 6 - Decimals, Floats, and Doubles
 
05:26
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
Removing Decimals with the INT and TRUNC Functions
 
03:51
Check out my Blog: http://exceltraining101.blogspot.com When you want to remove decimal numbers and not be bothered with rounding there are two functions that can do that: INT and TRUNC. This video gives you a quick example on how it's done. Feel free to provide a comment or share it with a friend! --------------------------------------- #exceltips #exceltipsandtricks #exceltutorial #doughexcel #exceltips #exceltipsandtricks #exceltutorial #doughexcel #exceltips #exceltipsandtricks #exceltutorial #doughexcel #exceltips #exceltipsandtricks #exceltutorial #doughexcel #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 8377 Doug H
MSSQL - How to Get Numbers after the decimal
 
03:01
Example that shows how to get numbers after decimal (.)dot Also how to fix the following error The data types float and int are incompatible in the modulo operator. More info: http://howtodomssqlcsharpexcelaccess.blogspot.ca/2013/01/how-to-fix-error-data-types-float-and.html and here http://howtodomssqlcsharpexcelaccess.blogspot.ca/2013/01/mssql-how-to-get-numbers-after-decimal.html
Views: 1519 Vis Dotnet
How to Build an Alphanumeric Outline
 
09:04
This video explains what an alphanumeric outline is and how it works, then shows you how to build a strong one.
Oracle CURRENT_TIMESTAMP Function
 
02:37
https://www.databasestar.com/oracle-date-functions/ The Oracle CURRENT_TIMESTAMP function will display the current date and time in the session time zone. Just like the CURRENT_DATE function, it uses the session time zone, which is where you logged in from. This could be different to the database time zone. The syntax of the CURRENT_TIMESTAMP function is: CURRENT_TIMESTAMP ( [precision] ) The return type of this function is TIMESTAMP WITH TIME ZONE. The precision parameter is optional, and it lets you specify the number of fractional seconds to return. If this is omitted, it uses the default of 6. It’s different to the SYSTIMESTAMP function, because CURRENT_TIMESTAMP returns the session timezone, and SYSTIMESTAMP returns the database time zone. So, if I’m logging in from Melbourne, Australia, and the database is in London, England, then the CURRENT_TIMESTAMP will return a date and time that’s 10 hours ahead of SYSTIMESTAMP, and in a different time zone. It may be on the same day, or it could be a different day, depending on when I run the function. You can perform arithmetic on this function just like any other date value (e.g. CURRENT_TIMESTAMP - 7 for 7 days ago). However, it might be better to use interval data types so you can keep the original data type. For more information about the Oracle CURRENT_TIMESTAMP function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-date-functions/
Views: 162 Database Star
MySQL 32 - FLOAT and DOUBLE Data Types
 
06:23
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: 6623 Caleb Curry
MSSQL -  Rounc decimal to 2 decimal places
 
00:46
more info http://howtodomssqlcsharpexcelaccess.blogspot.ca/2018/02/mssql-round-decimal-to-2-decimal-places.html
Views: 322 Vis Dotnet
How To Display Zero Decimal Places for Mark Labels in Tableau
 
01:21
In this silent video, you'll learn how to display mark labels with zero decimal places in Tableau. Read the full article here: Displaying Zero Decimal Places for Mark Labels -- http://kb.tableau.com/articles/howto/displaying-zero-decimal-places-for-mark-labels ____________________________________________________________________ 1. On the Marks card, Right-click the field on Label and select Format. 2. In the Default section, click the drop-down arrow next to Numbers. 3. Select Number (Custom). 4. Change the number of decimals to 0. ____________________________________________________________________ Subscribe to the Tableau YouTube channel here: [link: http://www.youtube.com/subscription_center?add_user=tableausoftware] Free Trial of Tableau: [link: https://www.tableau.com/products/trial ]
Views: 14666 Tableau Software
ꘒ0003 Unicode Symbols Single byte and Multibyte Oracle Databases
 
02:33
 🐧 僠 僰 ♠ ♣ ♥ ♦ ⓭ ⧨
Views: 211 Geraldo Viana
Basic SQL Formatting
 
02:05
How I like to format SQL statements in order to be quickly and easily read and understood.
Views: 1100 Daniel Meyer
Setting number fields to 1 decimal place
 
00:55
This tutorial will show you how recognise if a number field needs to be set to 1 decimal place
Views: 13173 BosworthA2ICT
SQL with Oracle 10g XE - Using CREATE TABLE to Build a Table
 
08:17
In this video I use the CREATE TABLE command to create three tables: Books, Publisher, and Author. I use these three tables as sample data. The code I entered in is: CREATE TABLE BOOK ( BOOK_ID VARCHAR(4) PRIMARY KEY, ISBN_10 VARCHAR(10), ISBN_13 VARCHAR(13), TITLE VARCHAR(50), CATEGORY VARCHAR(15), PRICE DECIMAL(6,2), BINDING VARCHAR(1), PUB_DATE VARCHAR(4), AUTHOR_ID SMALLINT, PUBLISHER_ID SMALLINT ); CREATE TABLE PUBLISHER ( PUBLISHER_ID SMALLINT PRIMARY KEY, PUBLISHER_NAME VARCHAR(40) ); CREATE TABLE AUTHOR ( AUTHOR_ID SMALLINT PRIMARY KEY, AUTHOR_LAST VARCHAR(25), AUTHOR_FIRST VARCHAR(20) ); I have to create each table individually in the SQL commands window. 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: 103131 Lecture Snippets
VBA SQL Strings - Tutorial for Beginner
 
36:14
In depth tutorial on how to build (SQL) Strings inside the VBA-Code-Editor. How to embed the different data types (numeric, date, decimal, and string) inside SQL strings and how to format longer SQL queries more readable. A text version of this topic with some extended information is available at http://codekabinett.com/rdumps.php?Lang=2&targetDoc=vba-sql-string-tutorial The database I used during the video is available for download at this URL: https://codekabinett.com/download/StringBuildingDemo_v2_1.zip
Views: 9229 codekabinett.com/en
Oracle SQL Tutorial 25 - ASCII and Unicode
 
03:33
In the previous video we talked about some of the most popular data types. We are going to discuss them in more detail. The data type we are going to start with is CHAR and NCHAR. I told you of both of these but I never explained the difference. That's because there is some other stuff I need to explain before I can explain the difference. This has to deal with what is known as character sets. When you have a string, there are only so many characters you are allowed to store in that string. The characters you are allowed to store is determined by what is known as the character set. A common character set is ASCII. This character set allows you to store English characters, numbers, and some symbols. ASCII started with 127 characters, and then they came out with the ASCII extended, which allows for up to 255 characters. Even with 255 characters though, we are limited in what we can store using one character set. If the computer only allows ASCII, we are going to be limited when working with different languages. Of course it works for some situations, but globalization of software has been a big thing with the development of the interwebs …and the movement towards a new world order (Revelation 13:7). That means that ASCII is no longer the best character set. It has largely been replaced with a character set known as Unicode. Oracle has a few Unicode character sets that we can use when we work with string data. When you start studying character sets, I can promise that you will run across the word encoding. Encoding refers to the way that the allowed characters can be stored on the computer. A computer doesn't just store a letter, everything has to be stored in binary. Unicode is the character set, but it has numerous different encodings. Essentially, the computer can store the same characters in multiple different ways, depending on which encoding is used. The most popular encodings for Unicode are UTF-8 and UTF-16. UTF stands for Unicode Transformation Format. In the next video we will be discussing these in detail and express their differences. Once we got that down, we'll be able to loop back around to data types. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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: 4901 Caleb Curry
Exercise 4-2 Converting A Date Format
 
02:31
Microsoft SQL Server 2005 Implementation and Maintenance
Views: 2436 idahotechy
Changing decimal settings windows 10 from comma "," to full stop "."
 
00:22
Short video to change your PC regional setting for decimals from comma to full stop.
Views: 13650 Nicky Marais
SQL Tutorial - 12: Inserting Data Into Tables
 
10:10
In this tutorial we'll learn to insert data into tables using the INSERT INTO statement.
Views: 152623 The Bad Tutorials
Introduction to UTF-8 and Unicode
 
11:07
This video gives an introduction to UTF-8 and Unicode. It gives a detail description of UTF-8 and how to encode in UTF-8. This is a video presentation of the article "How about Unicode and UTF-8" which was published on www.gamedev.net. Writing an STL-Style UTF-8 String Class - http://squaredprogramming.blogspot.com/2013/12/writing-stl-style-utf-8-string-class.html How about Unicode and UTF-8 - http://www.gamedev.net/page/resources/_/technical/general-programming/how-about-unicode-and-utf-8-r3322 www.squaredprogramming.com
Views: 131799 Squared Programming
MySQL 33 - Datetime, Date, Time Data Types
 
06:40
Next up on our MySQL to-do list is to learn about storing dates and times. There are various data types in MySQL for storing dates and times. It seems MySQL and databases likes to break everything up into multiple data types to make things more organized at the consequence of being confusing and annoying. This video is going to be talking about the DATETIME, DATE, and TIME data types. These are all used to store, you guessed it, dates and times. The one you choose depends on your needs. If you just need dates, choose DATE. If you just need times, choose TIME, if you need both stored together, choose DATETIME. Now you set a column one of these data types whenever you want every row for this field to have some sort of date, time or both…but how exactly is the data formatted? This requires us to understand some convention. For example, in the USA at least, if you have something like 4:30AM, by convention you know the hour is 4 and the minutes are 30. But this is just an agreed upon convention. MySQL has its own convention…For example 2017-02-02. The first thing is the year, the second is the month, and the third is the day. That is for the DATE. The convention for time is 22:54:30. The first is the hour (military time), the second is the minute, and the third is the seconds. Lastly, there can actually be fractions of seconds…up to microseconds! .123456. To use fractional seconds though you must specify to MySQL the precision of the TIME or DATETIME when you create it, for example DATETIME(6) would allow microsecond precision. How do you actually give a date to MySQL? By that I mean let's say you have a table with a column of DATETIME(6), and you want to give a value for that column, how do you format it? It's quoted. For example: '2017-02-02 22:54:30.333333' MySQL interprets this as a DATETIME. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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: 29146 Caleb Curry
How to Concatenate String Values with Integer values in SQL Server - TSQL Tutorial
 
10:23
How to Concatenate String and Integer Values in SQL Server ( + Sign vs CONCAT ) - TSQL Tutorial Working with Databases is fun. On daily basis we save data into tables in different columns and often we need to write queries which involve concatenation of multiple columns of different datatypes to produce our final output. In below example we have saved some data into #Customer Table which has Street Address column as string and zip as INT. we want to produce Full Address by concatenating these columns. To concatenate we can use + sign but this works only with String values. So if we have any Integer value/s we have to convert them to String first. We can use Cast or Convert function to convert Integer value to string. Also if there is any Null value among which values we are concatenating , our output will be Null by using + sign. To take care of that part we can use either ISNULL() or Coalesce Function to replace NULL with blank value in SQL Server. In SQL Server 2012 and Later versions, CONCAT function was introduced. You can concatenate multiple values by using this function. Fun part of this function is you don't have to worry about Null outcome as it will Ignore Null values and also you don't have to worry about converting INT into strings, It will take care of that automatically. So if you are using new versions such as 2012 or later, start taking advantage of this function. Blog post link for the video with script http://sqlage.blogspot.com/2015/03/how-to-concatenate-string-and-integer.html
Views: 14647 TechBrothersIT
SQL with Oracle 10g XE - Table Overview and Basic Data Types
 
05:34
In this video I take a look at the structure of tables I plan on using for my database and point on the relational links between the tables. I also discuss the primary key of the table as well as using it as a foreign key in a related table. I take a look at a few basic data types for field columns to include: CHAR = 255 characters VARCHAR = 255 characters SMALLINT = -32,768 to 32,767 INT = -2,147,483,648 to 2,147,483,647 DECIMAL = Numbers with a decimal value Date = In the format DD-MMM-YYYY 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: 17309 Lecture Snippets
SQL Prompt - SQL formatting in 30 seconds
 
00:31
Write, format, analyze and refactor your SQL effortlessly in SQL Server Management Studio and Visual Studio. Try SQL Prompt free: https://www.red-gate.com/products/sql-development/sql-prompt/
Views: 171741 Redgate Videos
Learning Zone : P/L SQL Programming how to convert Number to Word , By Dia Rashid
 
06:33
Oracle P/L SQL Programming how to convert Number to Word , Can be used in Oracle form 10g or Report 10g , example convert Total of value in numbers to be in word . By Dia Rashid. #OnlineLz.com #SQL #Python #MySql #Oracle
Views: 640 Dia Rashid
Fn Hello World
 
03:42
Views: 615 Fn Project
Display Numbers in a National Identity Number Format
 
05:51
Check out my Blog: http://exceltraining101.blogspot.com How to display numbers in the correct national identity number format such as a Social Security number format. Examples used are Social Security (US), Aadhaar Number (India) and National Health Service Number (UK). #exceltips #exceltipsandtricks #exceltutorial #doughexcel #exceltips #exceltipsandtricks #exceltutorial #doughexcel #exceltips #exceltipsandtricks #exceltutorial #doughexcel #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 2261 Doug H
Excel: How to Best Import External Data into Excel & Import data from the Web to Excel
 
11:16
Get the full course: http://www.xelplus.com/onlineAdvancedExcelCourse Excel has various tools that can help you easily clean up your raw data for further analysis. Apart from using formulas and formatting, there are two useful Excel features that let you easily clean up. One method is text to columns feature and the other to import external data. The Get External Data tool can be used to import and analyse data from other systems. This tool is also useful for importing data to run your dashboards or do further analysis using pivot tables, etc. Usually you can get data extracts from any system (e.g. “.dat” or “.csv” from Oracle, “.xml” files from SAP, etc.). These can be imported into Excel. Importing External Data also gives you control over the decimals and thousand separator, especially if you’re dealing with international companies. In the US, the decimal is dot and the comma is a thousand separator and in most European countries it’s the other way round, where the comma is a decimal and the dot a thousand separator. It’s always safest to Import it properly with the Excel Data Import wizard! After importing press Ctrl + T to create a table out of it. You can create a pivot table off this one, and when you do, even if you add more data to it, the pivot reflects the new data. Importing Data from the Web / Internet into Excel – creating web queries that refresh automatically: In Excel you can also import data directly from the web. You basically create a web query which you set to refresh automatically based on your preference. ➹ ➹ ➹ My Online Excel Courses ➹ ➹ ➹ Excel VBA & Macros ► http://bit.ly/LeilaVBA Excel Dashboards ► http://bit.ly/LeilaDashboards Excel Charts ► http://bit.ly/LeilaCharts Advanced Excel ► http://bit.ly/LeilaAdvancedExcel Excel Waterfall Charts ► http://bit.ly/LeilaWaterfall 🕮 Recommend Excel Resources 🕮 https://www.xelplus.com/resources/ ✉ Subscribe to my Newsletter ✉ Stay informed and get discounts when new courses come out: http://www.xelplus.com/
Views: 91868 Leila Gharani
Comprehensive Power BI Desktop Example: Visualize Excel Data & Build Dynamic Dashboard (EMT 1360)
 
30:35
Download File: http://people.highline.edu/mgirvin/excelisfun.htm See how to use Power BI Desktop to import, clean and transform Sales Tables from Multiple Excel Files and consolidate into a Single Proper Data Set that can be linked in a Relationship to other tables, and then build DAX Calculated Columns & Measures for Gross Profit that can be used in a Dynamic Dashboard with Map, Column Chart, Line Chart, Card and Slicer visualizations. During the whole process we will compare and contrast how the process is similar and different from Excel’s Power Query and Power Pivot DAX. The steps we will see in this video are: 1. (00:17) Introduction to entire process for Power BI Desktop, including looking at the finished Dashboard 2. (04:50) Import Multiple Excel Files From Folder 3. (05:44) Name Query 4. (06:02) Transform extension column to lowercase 5. (06:34) Filter Files to only include “.xlsx” file extensions 6. (07:05) Remove Columns 7. (07:18) November 2016 Power Query Update Problem 8. (08:05) Add Custom Column with Excel.Workbook Function to extract the Excel Objects from each File. 9. (09:40) Delete Content Column 10. (10:41) Filter to only include Excel Sheet Objects 11. (11:06) Filter to exclude sheets that contain the word “Sheet” 12. (11:40) Remove Columns 13. (11:51) Expand Data and Sheet Name Columns 14. (12:06) Change Field Names 15. (12:22) Change Data Types 16. (14:05) Add Custom Column to calculate Net Revenue Column then round Number.Round function. Then Add Fixed Decimal Data Type. 17. (15:59) Remove columns for Amount and Revenue Discount 18. (16:10) Close and Apply to add to Data Model 19. (17:05) Import Excel Manager Table. Change Data Types to Text. Close and Apply 20. (18:10) Create Relationship between Zip Code Columns 21. (19:03) Create DAX Calculated Column with the IF Function to Categorize Retail Data. Change Data Type. 22. (21:53) Create DAX Measures for: Total Revenue, Total COGS and Gross Profit. Add Currency Number Formatting with No Decimals Showing. 23. (24:28) Create DAX Measures for: Gross Profit Percentage. Add Percentage Number Formatting with Two Decimals Showing. 24. (25:35) Create Map Visualization for Zip Code & Gross Profit Data (Zip Code with relationship to Managers) 25. (26:20) Create Clustered Bar for Manager Names & Gross Profit Data (Zip Code with relationship to Managers) 26. (27:15) Create Clustered Column for Product & Gross Profit Data, with a Line Chart for Gross Profit Percentage 27. (28:19) Create Clustered Column for Payment Method & Gross Profit Data, with a Line Chart for Gross Profit Percentage 28. (28:45) Create Slicer for States. 29. (29:00) Create Card Visualization for Total Revenue, Total COGS, Gross Profit and Gross Profit Percentage. 30. (29:57) Summary Learn Power BI Desktop Basics. Introduction to Power BI Desktop. Getting Started with Power BI Desktop. Create Impactful Reports With Power BI Desktop. Microsoft Power BI.
Views: 113023 ExcelIsFun
Oracle SQL Developer Tutorial For Beginners  90   Arithmetic  Multiplication and Division
 
01:09
Oracle SQL Developer Tutorial For Beginners Series. This course introduces Oracle SQL Development for its subscribers. Currently this is based on Oracle 12c. The test environment is in Windows 10.
Views: 648 Sam Dhanasekaran
Date type conversion from any date format to any date format in DataStage
 
04:30
Use the type conversion functions to change the type of an argument. StringToDate Returns a date from the given string in the given format. You do not have to specify a format string if your string contains a date in the default format yyyy-mm-dd. Input: string (string) [,format (string)] Output: result (date) Examples: If the column mylink.mystring contains the string ″1958--08--18″, then the following function returns the date 1958--08--18. StringToDate(mylink.mystring) If the column mylink.mystring contains the string ″18:08:1958″, then the following function returns the date 1958--08--18. StringToDate(mylink.mystring,"%dd:%mm:%yyyy")
Views: 5226 WingsOfTechnology
Oracle EBS User Assignments Dynamic Pivot Table Dashboard
 
05:04
Learn how to create dynamic pivot tables from Oracle E-Business Suite. This tutorial, that I presented at Collaborate 2016, shows a User Assignments Dashboard that you can export to MS Excel
DevExpress WinForms: Getting Started with the Grid Control
 
07:27
The high performance DevExpress WinForms Data Grid is a feature-complete editing and data shaping component allowing your end-users to easily manage information and display it on-screen. It provides multiple data presentation modes: Standard Grid View, Banded and Advanced Banded Grid Views, Card, Tile and WinExplorer Views, Layout, Carousel and Split Presentation Views. This video walks you through the steps on getting started with the DevExpress Grid Control. Learn more on our website https://www.devexpress.com/Products/NET/Controls/WinForms/Grid/
Views: 196737 DevExpress
10- Oracle reports 11g – placeholder column – اوراكل ريبورتس
 
09:12
اهلا بكم فى درس جديد من دروس اوراكل ريبورتس Oracle reports 11g placeholder column نتعلم معا فى هذا الدرس: Place holder column The difference between placeholder column and formula column. How to create placeholder column. How to populate place holder column using formula column. .....................................­.................... لو عندك اى سؤال خش على الجروب : https://www.facebook.com/groups/oracle.askgad ......................................­.................... لمتابعة كل ماهو جديد من خلال صفحتنا https://www.facebook.com/askgad
Views: 962 Ask Gad
Characters in a computer - Unicode Tutorial UTF-8 (3/3)
 
15:07
This tutorial explains the utf-8 way of representing characters in a computer; later generalizing (high level) how any kind of data can be represented in a computer.
Views: 39942 dizauvi
ꘒ0001 Select From Oracle Errors ORA-00000 .. ORA-65536
 
01:56
ORA-nnnnn Errors with a Simple Query.
Views: 158 Geraldo Viana
SDU Tools   37   Format Data Type Name in T-SQL
 
01:27
SDU Tools are free tools for SQL Server developers and DBAs. This tool is used to format the name of a data type (involving maximum length, precision, and scale) as is needed when scripting database objects like tables. You'll find more info about SDU Tools and download details at http://www.sqldownunder.com/Resources/SDUTools
Views: 28 SQL Down Under
Talend Open Studio Using tConvertType
 
04:54
A tutorial on converting data types with Talend Open Studio using tConvertType
Views: 21693 Bekwam, Inc

24 hour fitness jobs application
Pregnancy loss australia newsletter formats
Layout of a cover letter uk example
Article writing service
Heading for apa annotated bibliography