The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT)
Write the query plz.
A B C
================
1 NULL 2
NULL 3 4
NULL 5 6
7 NULL NULL
O/P
C
=
2
4
6
Answer Posted / ravi gali
select c from tablename
where c IS NOT NULL;
Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
What is an oracle table?
material view and view disadvantages?
How to rename a column in an existing table?
How to call a stored function in oracle?
What is raw datatype?
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?
How to specify default values in insert statement using oracle?
Explain what are synonyms used for?
What is an oracle function?
What is index in Oracle?
Can you tell me how to add new column in existing views?how?How is possible?
How to see free space of each tablespace?
Is rowid unique in oracle?
How can we delete duplicate rows in a table?
What is PL/SQL ?