Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

creating blank column in view

789736Jan 11 2011 — edited Jan 11 2011
Hi guys, I have created a view which obviously gets data from different tables, however I will (in the future) have an additional row in this view obtaining data from somewhere but as of yet that data does not exist, is it possible to create a row in a view and stick a random value in it untill i have the data available to go back and change it. The reason i need this row is that im creating a report and I want to bring in the column with some random txt in it then once the data is available simply change the view which will save me having to change the report if you get my drift?

Any help would be greatly appreciated.
This post has been answered by Sven W. on Jan 11 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 8 2011
Added on Jan 11 2011
2 comments
4,620 views