Re: Difference between "SELECT *" and "SELECT COLUMN1, ..., COLUMNN"

In article <4M6j7.17818$Z2.228496_at_nnrp1.uunet.ca>, "Brian says...
>
>Hi,
>
>I was wondering what could cause differences between doing a "SELECT *" vs
>doing "SELECT COLUMN1, ..." (other than efficiency)
>
>I am having a problem where if I execute a query using "SELECT *" I don't
>have any records returned even though I know there should be. If I change it
>to "SELECT COLUMN1, etc" the record is returned successfuly. There are no
>errors or warnings returned in the first case. What could be causing the
>first select to fail?
>
>Thanks
>
>
>

what environment is this happening in? does this happen in sqlplus? if so -- can you do a simple cut/paste of it?

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp