how to Insert a computed field?
746024Jan 13 2010 — edited Jan 14 2010Hi all,
My sincere apologies if this is a wrong place for this post.
I have a table that takes in two values and should dynamically compute the third value and insert into database.
The purpose for this is based on this third value I have a lot of reports to be generated.
My table is:
col1 col2 col3
40 100% 40
15 32% 4.69
100 88% 113.64
So basically the third column is to be generated dynamically using first two fields (Col3 = (Col1*100)/Col2)
Can any body help me in writing a query for this kind of situation(in ORACLE APEX is much appreciated or PL/SQL or else oracle/SQL is also fine).
Thanks in advance.
Edited by: user5564103 on Jan 13, 2010 10:40 PM