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?

Re: ratio [message #222132 is a reply to message #222110] Fri, 02 March 2007 00:09 Go to previous message
flyboy
Messages: 1832
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.
Previous Topic: How to load .csv file into the oracle database table.
Next Topic: Two foreign keys for one column
Goto Forum:
  


Current Time: Wed Dec 07 22:08:20 CST 2016

Total time taken to generate the page: 0.05697 seconds