Home » SQL & PL/SQL » SQL & PL/SQL » perfect square
perfect square [message #212317] Thu, 04 January 2007 12:25 Go to next message
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
hello team.

i am facing problem while writing block.
can any one give me the logic.
i want to find whether the number which will i insert
is perfect square or not ?

i am too confused about it.
please give me the logic..rest i will do.

Re: perfect square [message #212323 is a reply to message #212317] Thu, 04 January 2007 12:47 Go to previous message
Messages: 136
Registered: January 2006
Location: stlouis MO USA
Senior Member

select case when floor(sqrt(49))=sqrt(49) then 'YES' else 'NO' end
from dual



Instead of 49 use your variable or column value.


Previous Topic: Can Index Size is bigger than table Size
Next Topic: group by problem, another one...
Goto Forum:

Current Time: Wed Oct 26 10:33:13 CDT 2016

Total time taken to generate the page: 0.09114 seconds