OraFAQ Forum: Training & Certification

Home » Other » Training & Certification » Interesting SQL Query

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Interesting SQL Query [message #293460]

Sun, 13 January 2008 01:31

agrawalpramil
Messages: 3
Registered: January 2008

Junior Member

Below is the input and output for a sql query:

Input Output

12 12.00
12.1 12.10
12.12 12.12
12.123 12.12

For any above input to sql statement there should be corresponding
output.

1. Is there any sql function available for this purpose?
2. How to write query without using any sql function to perform this?

Report message to a moderator

Re: Interesting SQL Query [message #293463 is a reply to message #293460]

Sun, 13 January 2008 01:34

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Who knows.
your input, your output, your function.

Report message to a moderator

Re: Interesting SQL Query [message #293465 is a reply to message #293460]

Sun, 13 January 2008 01:40

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What did you try and/or search?
Are you expecting we do your homework for you?

Regards
Michel

Report message to a moderator

Re: Interesting SQL Query [message #293471 is a reply to message #293460]

Sun, 13 January 2008 01:54

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

"Inputs" are numbers. "Output" is a formatted number. In order to format it, use the TO_CHAR function.

In SQL*Plus, you might use the SET NUMFORMAT to force desired output format. Other (GUI) tools (such as Forms or Reports Builder) will allow you to specify desired format for each item/field.
Bold terms can be researched at

Report message to a moderator

Previous Topic:	zig-zag calculation in pl/sql (merged)
Next Topic:	Binary Search

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 03:11:20 CST 2024