55 results
Open links in new tab
  1. Oracle SQL convert HEX to char - Stack Overflow

    Sep 10, 2012 · i am trying to convert a hexadecimal to character in Oracle ideally something like this for Microsoft SQL Server select …

  2. sql - How to cast LONG to VARCHAR2 inline - Stack Overflow

    Oct 28, 2017 · As stated by oracle experts themselves, for legacy reasons it's not possible to inline SUBSTR a LONG to a …

  3. Como obtener el numero del dia de la semana PL SQL ORACLE sin …

    la idea es poder obtener el numero de la semana en una funcion en ORACLE pero que esta siempre me devuelva los mismos …

  4. java - Como darle el formato DD/MM/YYYY a un campo tipo Date de …

    El resultado de esta consulta se descarga en un archivo .csv y lo que hace es que NO muestra los campos de fecha con formato …

  5. Converter data para dd/MM/yyyy ORACLE - Stack Overflow em …

    Aug 21, 2015 · Converter data para dd/MM/yyyy ORACLE Faça uma pergunta Perguntada 11 anos, 3 meses atrás Modificada 8 …

  6. How to remove leading zeroes from day and month values in Oracle, …

    I want to retrieve a date without the leading zeroes in front of the day and month values in a select statement. If I execute the …

  7. Oracle - Why does the leading zero of a number disappear when ...

    Jul 14, 2011 · In Oracle, when converting a number with a leading zero to a character, why does the leading number disappear? Is …

  8. Error- ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW ...

    Error- ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion Ask Question Asked 12 years, 2 months ago …

  9. Why is Oracle's to_char() function adding spaces? - Stack Overflow

    Sep 19, 2012 · Why is Oracle's to_char () function adding spaces? Ask Question Asked 18 years ago Modified 8 years, 10 months ago

  10. oracle database - How to extract week number in sql - Stack Overflow

    I have a transdate column of varchar2 type which has the following entrees 01/02/2012 01/03/2012 etc. I converted it in to date …