Add a record in the query

Dúvidas, dicas e truques de PL/SQL. Aqui também vão assuntos relacionados a pacotes, triggers, funções, Java-Stored Procedures, etc

Poston Thu, 20 Apr 2006 9:14 am

Anyone know any how you add a registry (can be empty) in the query. the lag () over () makes almost that, but not add a row. :?:
Location: sp

Poston Thu, 20 Apr 2006 9:53 am

I think the only way to do that is you put a UNION after your select ...
(Preferably, UNION ALL, because then he won't make the distinct)

Thus, you can insert a row in your query.
Location: Portland, OR USA

Thomas F. G

Você já respondeu a dúvida de alguém hoje?

Return to PL/SQL

Who is online

Users browsing this forum: No registered users and 11 guests