Home » SQL & PL/SQL » SQL & PL/SQL » Need help in a query.
icon5.gif  Need help in a query. [message #249108] Tue, 03 July 2007 07:16 Go to next message
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 140 times)
Re: Need help in a query. [message #249110 is a reply to message #249108] Tue, 03 July 2007 07:26 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Sorry, I don't download XLS files.

MHE
Re: Need help in a query. [message #249114 is a reply to message #249110] Tue, 03 July 2007 07:38 Go to previous messageGo to next message
yugamore
Messages: 23
Registered: December 2006
Junior Member
I have attached word doc.

thank you
  • Attachment: Table.doc
    (Size: 39.50KB, Downloaded 102 times)
Re: Need help in a query. [message #249120 is a reply to message #249114] Tue, 03 July 2007 07:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Need help in a query. [message #249121 is a reply to message #249114] Tue, 03 July 2007 07:43 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Laughing good one. Can't you just post the code in [code] and [/code] tags?

MHE
Re: Need help in a query. [message #249124 is a reply to message #249121] Tue, 03 July 2007 07:47 Go to previous messageGo to next message
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.
Re: Need help in a query. [message #249391 is a reply to message #249108] Wed, 04 July 2007 04:32 Go to previous messageGo to next message
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 128 times)
Re: Need help in a query. [message #249402 is a reply to message #249391] Wed, 04 July 2007 06:17 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
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:
  


Current Time: Wed Dec 07 16:22:35 CST 2016

Total time taken to generate the page: 0.12626 seconds