Solve This (? + ? + ?=30)
If 1111=R, 2222=T, 3333=E, 4444=N Then 5555=?
Guess the Hindi Muhawara from the following whatsapp Emoticons?
Sweet, Medicine, Film, Girl, City, Car, Place, Doggy all are name same, guess which word it is?
A girl is blind, deaf, dumb and uneducated too. A boy loves her. How would he propose without touching her?
Four Question, One Answer: One River Name, One Flower Name, One Film Name, One Actress Name?
Guess me who am I, I am the first on earth, the second in heaven...
Which Indian cricketer is known as "Brown Bradman"?
Which English poet, dramatist, and art historian, a pioneer in the European study of Far Eastern painting wrote.........
What nationality is Ilie N?stase, World No. 1 tennis player in 1973/1974, who won more than 100 ATP professional........
Display the records between two range I know the nvl function only allows the same data type(ie. number or char or date Nvl(comm, 0)), if commission is null then the text “Not Applicable” want to display, instead of blank space. How do I write the query?
You can use the decode function for the above requirement. Please find the query as below:
Ex: select ename,DECODE(NVL(comm,0),0,'Not Applicable',comm) from scott.emp;
suppose if i give '12345'
output should be:
Forgot Your Password?
2018 © Queryhome