Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Oracle Number Data-Type

Tags:

oracle

Just got a little question when a column got the Datatype Number(6,3) will this work?

1234
1234.23
12345
123456

btw google didnt help me :/

like image 577
domiSchenk Avatar asked Dec 22 '22 06:12

domiSchenk

1 Answers

No, this won't.

NUMBER(6, 3) accepts 6 digits at all with 3 being after the decimal period.

This gives us only 3 digits possible before the period, and, hence, maximal value possible to store is 999.999

like image 57
Quassnoi Avatar answered Jan 25 '23 21:01

Quassnoi
Sign in to Comment

Related questions

ASP Membership Odd Problem
How would you enforce DRY (Don't Repeat Yourself) in a SQL script?
Determining Oracle Database Instance
PLSQL : Get sum for each day of week and total sum for week in a single query
Connect to an Oracle 10g database with Microsoft ODBC for Oracle
Converting a string to an integer in oracle
How can I keep my DB connection from failing when the network is unstable?
Is it recommended practice to use uniform extent sizes in Oracle tablespaces?
PL/SQL: Retrieve names of procedures and functions within a package
Differences between SQL Plus and "regular" SQL?
CREATE TABLE reverse engineering in Oracle
Create or replace role?
SAS to Oracle ODBC - passing a SAS table INTO the database
c# datatypes -> oracle datatypes
Checking if a collection element exists in Oracle
Why would Oracle ignore a "perfect" index?
How to uninstall Oracle 10g? I don't see any uninstall tool for this
Encryption inside oracle
Oracle -- Import data into a table with a different name?
Why does JDBC driver pad some blank characterS other a queried field, from an Oracle Database?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!