OraFAQ Forum: SQL & PL/SQL » Need help in a query.

Home » SQL & PL/SQL » SQL & PL/SQL » Need help in a query.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Need help in a query. [message #249108]

Tue, 03 July 2007 07:16

yugamore
Messages: 23
Registered: December 2006

Junior Member

Hi All,

I have attached snap shot of table. I want to get name of the columns which have NULL values along with their surveyid.

Expected output 1s also given in the attachment.

Thank you for your help.

Attachment: Table.xls
(Size: 13.50KB, Downloaded 479 times)

Report message to a moderator

Re: Need help in a query. [message #249110 is a reply to message #249108]

Tue, 03 July 2007 07:26

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Sorry, I don't download XLS files.

MHE

Report message to a moderator

Re: Need help in a query. [message #249114 is a reply to message #249110]

Tue, 03 July 2007 07:38

yugamore
Messages: 23
Registered: December 2006

Junior Member

I have attached word doc.

thank you

Attachment: Table.doc
(Size: 39.50KB, Downloaded 446 times)

Report message to a moderator

Re: Need help in a query. [message #249120 is a reply to message #249114]

Tue, 03 July 2007 07:42

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

We don't either download word document.
We don't download any file format that may contain virus.
In summary, just plain text (txt) or bitmap (bmp) files are safe.

Regards
Michel

Report message to a moderator

Re: Need help in a query. [message #249121 is a reply to message #249114]

Tue, 03 July 2007 07:43

Maaher
Messages: 7065
Registered: December 2001

Senior Member

good one. Can't you just post the code in [code] and [/code] tags?

MHE

Report message to a moderator

Re: Need help in a query. [message #249124 is a reply to message #249121]

Tue, 03 July 2007 07:47

caliguardo
Messages: 107
Registered: February 2007
Location: Chennai

Senior Member

Your attachment does not have any create table,insert data scripts. Please do post the scripts.

Report message to a moderator

Re: Need help in a query. [message #249391 is a reply to message #249108]

Wed, 04 July 2007 04:32

balaji23_d
Messages: 123
Registered: February 2007

Senior Member

Hi

I herewith attached the text file format

Attachment: table[1].txt
(Size: 0.47KB, Downloaded 458 times)

Report message to a moderator

Re: Need help in a query. [message #249402 is a reply to message #249391]

Wed, 04 July 2007 06:17

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

select surveyid,
       decode(company,null,'COMPANY')||' '||
       ... same for other columns ...
from mytable
where company is null
   or ... same for other columns ...
/

Regards
Michel

[Updated on: Wed, 04 July 2007 06:18]

Report message to a moderator

Previous Topic:	query for deleting the minimum updated record.
Next Topic:	Executing Default Parameter in Procedure

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 05 16:03:11 CST 2024