Hi, I am working with ORACLE 11g, making a query to the table through sqlplus, then I save the result of the query in a log. The problem is that there are two fields that return an amount of sum and have many characters so they do not look like scientific notation and the other one with #. What format can I give you so that they appear completely to me? Attached image with result of the query. This is my query.sql:
SET PAGESIZE 84
SET NEWPAGE 0
SET LINESIZE 80
SET UNDERLINE -
SET HEADING ON
COLUMN ORIGEN HEADING 'ORIGEN' Format a8
COLUMN TIPO HEADING 'TIPO' Format a20
COLUMN CANTIDAD HEADING 'CANTIDAD' Format a20
COLUMN TOTALSALDO HEADING 'SALDO' Format a20
COLUMN fecha HEADING 'FECHA' Format a20
SELECT DISTINCT a.ORIGEN,DECODE (B.TIPOREGISTRO,'AbonoI', 'BST-ARCHIVO','ARCHIVO')"TIPO", a.TOTALREGISTROS AS CANTIDAD, a.TOTALSALDO AS SALDO, a.fecha
FROM SALDO_USER.REGISTROCONTROL a, SALDO_USER.REGISTROSDETALLE B
WHERE TO_CHAR(TRUNC(a.fecha),'YYYYMMDD')=TO_CHAR(SYSDATE,'YYYYMMDD')
AND B.IDCONTROL IN (A.IDCONTROL)
ORDER BY a.fecha DESC;
EXIT;
Where AMOUNT AND BALANCE are what I need to modify to obtain the correct values.
