Home » SQL & PL/SQL » SQL & PL/SQL » testing an equation
testing an equation [message #1288] Wed, 17 April 2002 13:05 Go to next message
Lee
Messages: 56
Registered: May 1999
Member
Hi,

I have a procedure that is bombing on a certain line and I wanted to test it in SQL-PLUS only I'm having trouble getting the syntax right.

Basically I need to test the following equation:

some_number := FLOOR(LOG(10,ABS(207.0306)));

How do I print out some_number in SQL?

Thanks

Report message to a moderator

Re: testing an equation [message #1289 is a reply to message #1288] Wed, 17 April 2002 14:08 Go to previous message
Mike
Messages: 417
Registered: September 1998
Senior Member
select FLOOR(LOG(10,ABS(207.0306)))
from dual;

That's it

Report message to a moderator

Previous Topic: Another command in place of substr
Next Topic: How to pass Java value objects to Stored procedures
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 20:08:30 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.