Home » SQL & PL/SQL » SQL & PL/SQL » ratio
ratio [message #222110] Thu, 01 March 2007 22:19 Go to next message
mudalimuthu
Messages: 64
Registered: May 2005
Location: Bangalore
Member
I have the following ratio

60:40

i want simplified format as follows
3:2

will it be possible to arrive through sql?

Report message to a moderator

Re: ratio [message #222132 is a reply to message #222110] Fri, 02 March 2007 00:09 Go to previous message
flyboy
Messages: 1903
Registered: November 2006
Senior Member
First you should pick the algorithm.
I would prefer implementation in pl/sql.
However you may try using sql hierarchical queries, maybe it could be achievable too.

Report message to a moderator

Previous Topic: How to load .csv file into the oracle database table.
Next Topic: Two foreign keys for one column
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 05 12:48:06 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.