hi all how can we compare two null values in SQL...
for example.,
select ename,commissio n from emp e
where commission=(sel ect commission from emp where ename=e.ename)
suppose commission of the employee is null it is not comparing the null value... it is omitting the record which has null value in commision....
this problem is too complex when we check for multiple queries......
...
trysenthil
Last Activity: Nov 17 '08, 11:45 AM
Joined: Sep 27 '07
Location:
-
comparision of null values in sql
-
thank you for your message thnk you very much -
displaying the date through sql query
hi all.,
i want a query from u.,which must display me like this.,
[for eg., select to_char(sysdate ,'dd-month-yyyy') from dual ]
is displaying me.,
07-september-2007
suppose i want a result as
seventh september 2007...... what will be the query for displaying this type of result..... -
diffrence between decode and case
hi all., i want to know the diffrence between the decode and case function that is available in oracle....help me ya... -
thanks for your clarification...Leave a comment:
-
regarding comparison in sql
thanks,
one more doubt:
while retrieving the data that is stored in oracle dbase., and comparing that particular field eg.name we are writing as name='INDIA' .
how the comparison works with the name if i have 'iNDIA' OR 'INdia' -
thanks,
one more doubt:
while retrieving the data the is stored in oracle dbase., and comparing that particular field eg.name we are writing as name='INDIA' .
how the comparison works with the name having diffrent cases. at that time whether it ignores the case?...
i have a query
select ename from emp
where name='abc' ***** can i give like this...... basically i am a beginner to oracle........Leave a comment:
-
regarding the data storage in oracle
in what case the datas get stored in oracle.
i think that it is in upper case.
but i have doubt.
one more : if the datas defaultly get stored as Ucase in oracle... is there is any possibilities for me to change the case..... i think no...but yet not satisfied...... ... -
regarding oracle and sql
in what case the datas get stored in oracle.
i think that it is in upper case.
but i have doubt.
please some one help me to recover from this..
one more : if the date defaultly get stored as Ucase in oracle... is there is any possibilities for me to change the case..... i think no...but yet not satisfied...... ... please someone help me
No activity results to display
Leave a comment: