How F can be correct?! Okay, in oracle documents it is mentioned like : FLOOR returns the largest integer equal to or less than n.
But why it returns less than inputted value?? (select floor(15,7) from dual => output is 15)
That statement is proper for CEIL function for my point of view.
Can anyone help me to overcome this simply seem but complicated question?
Floor takes the minimum integer value while CEIL takes the largest integer value.
SELECT FLOOR('100.2') FROM DUAL; //op: 100
SELECT CEIL('100.2242') FROM DUAL;//op: 101
How F is correct.
In case argument is passed in a negative. eg -1.4. The output is -2.
But -1 is greater than -2. And, its contrast with option F.
F. FLOOR returns the largest integer less than or equal to a specified number.
select floor(-1.4) from dual;
o/p
---2
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
5cff9a8
2 months agoDrexan
2 months, 1 week agohmatinnn
1 year, 1 month agoLee_jong_suk
1 year agoGuru_C
1 year, 5 months agoProctored_Expert
2 years agoMahdiHamdii
2 years agoboddoju
2 years, 1 month agoJ4vi
1 year, 10 months agoRik92
1 year, 7 months agopawanl
2 years, 4 months ago