select « column « Java Database Q&A





1. Selecting all columns but one    coderanch.com

Hi, I have about 30+ columns in my table. I want to select all columns but one column (which has to come from another table). Do I have to specify each column name in the select clause or is there an easier and a better way of doing it? All help appreciated. Harsha [ August 26, 2005: Message edited by: Harsha ...

2. how to select particular column name    coderanch.com

3. Can I Select column A OR column B ?    coderanch.com

Hi All, Just wondering if this is a possibility. I need to do a pretty complicated select statement, and one of the things I need to do is select a time value. The problem I have is, I need to use the time value in Column A, only if the value in Column B is null, if the value in Column ...

4. How to parse column data using select??    coderanch.com

Hi I have a small problem regarding parsing data in a column using only select statement Say there is some data "abc;def;ghi;" in a column which needs to be displayed as abc def ghi using only select statement. I know we can write a procedure to easily do this but i would like to know how it can be done using ...