Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Hardcode value in sql statement

Mrudula BandaruJun 22 2013 — edited Jun 22 2013

Hi,

This may be a simple thing which I'm missing.

I'm trying to hardcode numeric value in my SQL statement

'1.0000' AS NUMBER (10,4) - It returns value as 1 instead of 1.0000

'1.1255' AS NUMBER(10,4) - returns 1.1255

I need my o/p to be as 1.0000 not as 1.Is there anyway I can get the result as I'm looking for

Thanks in advance

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 20 2013
Added on Jun 22 2013
3 comments
2,312 views