rameshreddy


{ City } bangalore
< Country > india
* Profession * trainee engineer
User No # 5943
Total Questions Posted # 2
Total Answers Posted # 1

Total Answers Posted for My Questions # 4
Total Views for My Questions # 10517

Users Marked my Answers as Correct # 1
Users Marked my Answers as Wrong # 0
Questions / { rameshreddy }
Questions Answers Category Views Company eMail

while loading data into database how can u skip header and footer records in sql*loader

Oracle,

1 SQL PLSQL 5810

I have a table like this Table Name:Products Productid Price 1 10 1 10 2 20 3 30 3 30 But i want to output like this. productid price 2 20. please replay me.

TCS,

3 Oracle General 4707



Answers / { rameshreddy }

Question { Wipro, 18263 }

i have table T!.

A B C D
NULL 1 2 3
4 NULL 5 6
7 8 NULL 9
10 11 12 NULL.


I WANT COUNT OF NULL VALUES IN TABLE. WRITE A QUERY.


Answer

select a1+b1+c1+d1 from
(select count(case when a='null' then 1 end) a1,
count(case when b='null' then 1 end) b1,
count( case when c='null' then 1 end) c1,
count(case when d='null' then 1 end) d1 from t1)

Is This Answer Correct ?    1 Yes 0 No