August 17, 2008 at 10:22 am
So sorry...I don't post much so am not sure where or why the text is dropping out. Here's a section with no formatting:
[definition of schema elements]
schema element :
table definition
view definition
domain definition
character set definition
collation definition
transliteration definition
assertion definition
trigger definition
user-defined type definition
user-defined cast definition
user-defined ordering definition
transform definition
schema routine
sequence generator definition
grant statement
role definition
drop schema statement (p520)
August 17, 2008 at 2:39 pm
(I was taught that a view is a virtual table and haven't been able to find any reputable source that considers a view a "persisted query." Can you clarify?)
Yes Views are virtual tables because they are persisted but are created with a SELECT statement which makes them DML(data manipulation language). In the second link download the PDF file in the first link by Joe Celko et al and go to chapter 2.
http://www.craigsmullins.com/viewnw.htm
http://unjobs.org/authors/joe-celko
Kind regards,
Gift Peddie
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply