Posts by Alexandre Quirino de Faria • 49 points
4 posts
-
0
votes1
answer689
viewsQ: Long to Varchar data conversion
I am trying to convert data from a Long field to Varchar, but when I do the procedure, it is returning the following error: ORA-01422: Exact extraction returns more than the requested number of…
-
1
votes2
answers7751
viewsQ: ORA-06502 - string buffer too small numerical or value - Long Field
Good morning, I’m performing a query to query data in a Long-type field. I created the following Function to bring the data: CREATE OR REPLACE FUNCTION "SEARCH_LONG" (r rowid) return varchar2 is…
-
0
votes2
answers102
viewsA: Relationship dates as a result of SQL query on Oracle
Follow the command I made and the result SELECT ATENDIME.CD_ATENDIMENTO, ATENDIME.CD_PACIENTE, PACIENTE.NM_PACIENTE, ATENDIME.DT_ATENDIMENTO, ATENDIME.DT_ALTA,LAG(DT_ALTA,1)OVER (ORDER BY…
-
2
votes2
answers102
viewsQ: Relationship dates as a result of SQL query on Oracle
Good afternoon, When carrying out the following consultation SELECT CD_ATENDIMENTO,DT_ATENDIMENTO FROM ATENDIME I get the following return However, I need to return only the results that have less…