http://snippets.dzone.com/posts Sun, 27 Jul 2008 09:25:22 GMT DZone Snippets: database code http://snippets.dzone.com/posts/show/4077 How to log things in the database <br /> <br />Create the table: <br /><code> <br />create table TMP_LOG (HORA date, ENTRADA varchar(4000)); <br /></code> <br />Write the things I need to the table: <br /><code> <br />INSERT INTO TMP_LOG (HORA, ENTRADA) VALUES(SYSDATE, <br /> 'V_NOM_DESTINATARIO1: '||V_NOM_DESTINATARIO1||', V_DOM_DESTINATARIO1: '||V_DOM_DESTINATARIO1|| <br /> ', P_NOM_DESTINATARIO_2: '||P_NOM_DESTINATARIO_2||', P_DOM_DESTINATARIO_2: '||P_DOM_DESTINATARIO_2|| <br /> ', B_DESTINATARIO: '||B_DESTINATARIO|| <br /> ', V_NOM_DESTINATARIO2: '||V_NOM_DESTINATARIO2||', V_DOM_DESTINATARIO2: '||V_DOM_DESTINATARIO2); <br /> <br /></code> <br />Consult the things written: <br /><code> <br />select * from tmp_log order by hora desc; <br /></code> <br />Dont forget to drop it at the end: <br /><code> <br />drop table TMP_LOG; <br /></code> <br /> Wed, 30 May 2007 16:59:19 GMT http://snippets.dzone.com/posts/show/4077 koke24 (Koke)