Home » SQL & PL/SQL » SQL & PL/SQL » Created a calculated field from a view
Created a calculated field from a view [message #10917] Tue, 24 February 2004 11:14 Go to next message
CC
Messages: 2
Registered: October 2000
Junior Member
I have these reports driven by views. I've been asked to create a calculated field pulling data from one view and storing the calculated field in the other view.  Can you cross reference views? Or will I have to create a new view in order to accomplish this?

Report message to a moderator

Re: Created a calculated field from a view [message #10918 is a reply to message #10917] Tue, 24 February 2004 11:22 Go to previous message
Satish Shrikhande
Messages: 167
Registered: October 2001
Senior Member
This is what i do

Select "all data" from View
Union
Select "calculated data" from View

but you can cross reference views .

create view view1 as
select "calculated data " from view

Satish Shrikhande
http://www.freewebs.com/oracledba/oracle.htm

Report message to a moderator

Previous Topic: All Oracle Processes
Next Topic: systemmode
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 07:54:22 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.