Columns and Data Types: Databases for Developers #2

Подписаться 25 тыс.

Просмотров 25 тыс.

50% 1

Tables may be the foundation of your database. But you need something to hold them up:
Columns!
Choosing a data type for a column is one of the most important decisions you can make for
In this episode Chris gives a run down of common data types and what you use them for.
For further details on these, check the Oracle Database Data Types documentation: docs.oracle.com/database/122/S...
Take the Databases for Developers FREE SQL course at devgym.oracle.com/devgym/data...
Subscribe for more videos on database, SQL and magic: / themagicofsql
For daily SQL tips follow SQLDaily on Twitter: / sqldaily
============================
The Magic of SQL with Chris Saxon
Copyright © 2018 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.

Наука

Опубликовано:

8 ноя 2018

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 5

@surendradama5628 2 года назад

Chris.. so cool. you are spending so much time for each and every video. It will help a lot for Oracle community

@TheMagicofSQL 2 года назад

Thanks Surendra!

@RanjeetKumarR 5 лет назад

thanks you so much.

@smartsekar9727 2 месяца назад

Sir what is decimal presicion. Scale used how it store values.according size of values

@TheMagicofSQL 2 месяца назад

"p is the precision, or the maximum number of significant decimal digits, where the most significant digit is the left-most nonzero digit, and the least significant digit is the right-most known digit. Oracle guarantees the portability of numbers with precision of up to 20 base-100 digits, which is equivalent to 39 or 40 decimal digits depending on the position of the decimal point. s is the scale, or the number of digits from the decimal point to the least significant digit. The scale can range from -84 to 127." docs.oracle.com/en/database/oracle/oracle-database/23/sqlrf/Data-Types.html#GUID-9401BC04-81C4-4CD5-99E7-C5E25C83F608