joel garry wrote:
> On Dec 16, 7:56 am, DA Morgan <damor..._at_psoug.org> wrote:
>> William Robertson wrote:
>>> On Dec 15, 7:52 pm, "shakespeare" <what..._at_xs4all.nl> wrote:
>>>> No, this is not
>>>> CREATE SCHEMA
>>>> but
>>>> CREATE PROCEDURE "schema.procname"
>>> I was responding to David Fitzjarrell's comment that "CREATE SCHEMA"
>>> is available from 10g onwards.
>> CREATE SCHEMA is listed in the Oracle 7 Server SQL Language Quick
>> Reference (1987).
>
> Indeed, it's on page 4-221 of http://download.oracle.com/docs/pdf/A32538_1.pdf
> (And check out the typo on page A-18)
>
> The bit about being able to roll back multiple DDL has long been a
> source of wonder for me, begging the question of implicit commits on
> other DDL.
>
> jg
> --
> @home.com is bogus.
> "Some somehow observe the day,but are vexed, I believe, that the body
> of people profane it, and blessed be God no authority yet compels them
> to keep it." - Boston Puritan Samuel Sewall, Christmas Day 1685 - when
> celebrating Christmas was illegal in New England
We should perhaps note that these are the same writers that gave us the
nightmare of BHCR monitoring and so many other gems. <g>
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Tue Dec 18 2007 - 00:25:56 CST
