SQL create view statement

Question

I am new to SQL Developer. I have to create a view to approach the sample output list below:

The table structure is:

SITE(Site_ID, Region, Description, Latitude, Longitude, Altitude); 
MEASUREMENT(Site_ID, Recorded_On, Name, Value, Outlier_Indicator);

Here is my script, it is working as I followed the advices.

create view Site_Outlier_Incidents AS 
    select 
        Site_ID, Name, Outlier_Indicator,
        count (SITE.Site_ID) as Number_Of_Incidents
    from Site SITE
    left join Measurement MEASUREMENT on MEASUREMENT.site_ID = SITE.Site_ID
    where Name = 'E.Coli'
    group by
        Site_ID, Name, Outlier_Indicator;

Typo? You've missed comma: ...Outlier_Indicator, count (SITE.Site_ID).... — Dmitrii Bychenko
– Dmitrii Bychenko, Commented Sep 7, 2017 at 9:39
And there's an extra right parentheses at the end. Remove it. — jarlh
– jarlh, Commented Sep 7, 2017 at 9:41
Thanks, I edited all of the typing mistakes but there is still an error report: ORA-00922: missing or invalid option — Isol. L
– Isol. L, Commented Sep 7, 2017 at 9:48

Manarjan Singh Ghai · Accepted Answer · 2017-09-07 09:52:03Z

1

Use create or replace view instead of alter view

answered Sep 7, 2017 at 9:52

Manarjan Singh Ghai

1232 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Isol. L Over a year ago

May I be able to combine those two statements into one create view statement? How do I approach it?

Manarjan Singh Ghai Over a year ago

the syntax is create or replace view view_name as (your query);

Collectives™ on Stack Overflow

SQL create view statement

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related