Extract, ten, hundred, thousand, decimal

Dúvidas, dicas e truques de SQL, Select, Update, Delete, cláusulas, operações com joins, Funções em SQLs, etc
  

Poston Fri, 03 Mar 2006 9:08 am

Does anyone know if aí is there any command to extract the dozen, hundred, thousand etc?

ex.

extract ten (1223.53):: Returns 20 extract hundred (1223.53):: Returns 200 extract thousands (1223.53):: returns 1000 extract decimal (1223.53):: Returns 53 thanks!

[] ':
MuLtAnI
Location: Videira - SC


Poston Fri, 03 Mar 2006 9:18 am

Oops, I traveled in mayonnaise, just do the mod: oops: hundred mod (.1000 1152.52)-mod (152.52 .100) dozen mod (1152.52 .100)-mod (152.52 .10) thousand mod (11152.52 .10000)-mod (.1000 11152.52) I just need to know if there's a function to extract the decimal.

[] 's
MuLtAnI
Location: Videira - SC


Poston Fri, 03 Mar 2006 9:43 am

Attempts to use TRUNC.
Code: Select all
SQL> select 1234.56 - trunc(1234.56) resp from dual;

      RESP
----------
       .56

SQL>
:-o
dr_gori
Location: Portland, OR USA

Thomas F. G

Você já respondeu a dúvida de alguém hoje?
http://glufke.net/oracle/search.php?search_id=unanswered

Poston Fri, 03 Mar 2006 10:09 am

Well remembered!

Is the q can be time without shake!

Hug!!!
MuLtAnI
Location: Videira - SC




Return to SQL

Who is online

Users browsing this forum: No registered users and 2 guests