Re: Trouble with views - quick one this

In article <379D8A9F.3368F9CA_at_tiu.co.uk>,

        Peter Shaw <peter.shaw_at_tiu.co.uk> writes:
> OK, so I've got Oracle loaded and working (NT) and I'm having a bit of
> fun working my way through the PL/SQL examples from the online
> documentation, but one thing is bugging me - views. I can find
> references to creating and altering them, but how do you "look at" or
> "open" them, what am I missing, which part of Oracle does this, am I on
> the right planet? I see that there is a view called "sales" in the demo
> database - I can't even do anything with this!

In SQL*Plus:

select * from sales;

This is fundamental and should be really obvious. I think you need to ask yourself if you are reading the right documentation. You really need to get to grips with SQL before delving too deeply into PL/SQL.

--
Regards,

Richard Senior
London, England Received on Tue Jul 27 1999 - 06:09:42 CDT