I use sql developer, I create a query, as the textbook says NAME_VARIABLE FLOAT(5, 2) , but writes an error - the syntax is not correct. The documentation says - FLOAT[(M,D)] attribute M indicates the number of characters displayed to the user, and the attribute D indicates the number of digits following the decimal point. How to be? And what to put in place of М , if I don’t know in advance how many characters a number will consist of?

  • one
    specify the type of database please ... - MaxU

1 answer 1

Because You are using sql developer - I will assume that you are working with Oracle DB.

Oracle DB documentation states that FLOAT([p]) accepts only one parameter — precision.

Judging by your description, you meant NUMBER(M,D) :

 NAME_VARIABLE NUMBER(5, 2)
  • Thank. So here - site-do.ru/db/sql2.php is not an exact description - YuriiS
  • @YuriiS, you did not specify the type of database in question. After seeing the sql developer , I concluded that you are working with Oracle DB. Your link describes data types in MySQL - and the description is right there ... - MaxU
  • MaxU, I see. I study on the basis of Oracle DB, and the description read on MySQL turns out. Yes, I graduated, damn ...))) - YuriiS
  • @YuriiS, this is all because MySQL now owns Oracle :-D - MaxU
  • MaxU, of course, now I will know)) - YuriiS