Search results for query: *

Try including the function nz([amount]). the "NZ" changes all null values to zero.

thanks for your help...

I had just figured that out before I got notification that you guys figured it out.&nbsp;&nbsp;Thanks for your help.&nbsp;&nbsp;This is a great service for all of us who are novices.<br><br>Thanks

When i get a message from outside my organization, I can &quot;reply&quot; to the sender without issue. If however, there are CCs, my email for some reason cuts off the domain names and shows only the aliases that were in the senders address book. My email system looks to our internal sever for...

I tried that and it still gave me an error.&nbsp;&nbsp;Is &quot;Spool&quot; a command you can use from the buffer or does it have to be within the context of a SQL file?&nbsp;&nbsp;<br><br>Any other ways you can think of to get the data and send it out to a text file from the SQL&gt; prompt?

I tried the following and still got an error:<br><br>SQL&gt; run<br>&nbsp;&nbsp;1&nbsp;&nbsp;spool c:\temp\output.txt<br>&nbsp;&nbsp;2&nbsp;&nbsp;select...

This is what is contained in the buffer.&nbsp;&nbsp;I just run it from the SQL&gt; prompt and <br>i get the following error:<br><br>ERROR at line 5:ORA-00933: SQL command not properly ended<br><br>select...

Mike,<br><br>Our MIS department uses an Oracle database.

Without programming, can I create a .buf file to run a routine to do a select statement and export it to text or spreadsheet format file for further use?&nbsp;&nbsp;I tried using spool but am doing something wrong.<br><br>thanks

If I know the table names in an Oracle database is there a way I can find out the field names and data types without having to go to the data model?