Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-02-2021 01:01 PM
You cant delete data from a view, but you can create or replace temp view with the same name with the data you want deleted filtered out.
For example, if you have a view myview, that you want to delete the record with id=2, do the following:
CREATE OR REPLACE TEMP VIEW myview
as
select * from myview where id = 2;
Franco Patano
Stragetic Data and AI Advisor
Stragetic Data and AI Advisor