Posts by Heitor Scalabrini • 781 points

• 2

  votes

  2

  answers

  284

  views

  A: SQL Oracle - Clob to Number

  The problem is the values with point and not comma, to convert to numeric value you need to do a REPLACE, Replacing . (dot) by , (comma) Following example: --CRIANDO TABELA TESTE CREATE TABLE…

  sql query oracle float

  answered 4 years, 10 months ago Heitor Scalabrini 781

• 0

  votes

  1

  answer

  51

  views

  A: Query problem to filter different fields in the same SQL table

  I noticed some errors in your code: from stinsights.user_usage as u join stinsights.user_usage as u2 o código aqui You are doing a stinsights.user_usage table and then you are relating to yourself…

  sql query

  answered 4 years, 10 months ago Heitor Scalabrini 781