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. :?:
mello
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.
dr_gori
Location: Portland, OR USA

Thomas F. G

Você já respondeu a dúvida de alguém hoje?
http://glufke.net/oracle/search.php?search_id=unanswered



Return to PL/SQL

Who is online

Users browsing this forum: No registered users and 11 guests