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

On Wed, 29 Aug 2001, brian.ross_at_home.com wrote:

> 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?

Are you using some programming language for this and can't retrieve from a cursor, or is this happening in SQLPlus?

If former, can you check if the query runs correctly in SQLPlus first?

-- 
Galen Boyer
It seems to me, I remember every single thing I know.