Valentin Minzatu wrote:
> On Mar 22, 8:41 pm, DA Morgan <damor..._at_psoug.org> wrote:
>> Brian Peasland wrote:
>>> Matthias Hoys wrote:
>>>> How about:
>>>> CREATE USER LIKE ...
>>> That would be a great idea! Either that, or the ability to use
>>> DBMS_METADATA.GET_DDL to reverse engineer the CREATE user statement
>>> *along with* the necessary GRANT statements.
>>> Cheers,
>>> Brian
>> You mean like this?
>>
>> SQL*Plus: Release 10.2.0.2.0 - Production on Thu Mar 22 17:39:44 2007
>>
>> Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
>>
>> Connected to:
>> Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
>> With the Partitioning, OLAP and Data Mining options
>>
>> SQL> set long 1000000
>> SQL> select dbms_metadata.get_ddl('USER', 'UWCLASS') from dual;
>>
>> DBMS_METADATA.GET_DDL('USER','
>> ----------------------------------------------------------------
>>
>> CREATE USER "UWCLASS" IDENTIFIED BY VALUES '6DC6701F46477E93'
>> DEFAULT TABLESPACE "UWDATA"
>> TEMPORARY TABLESPACE "TEMP"
>>
>> SQL>
>>
>> Now if only it provided quotas and privs. <g>
>> --
>> Daniel A. Morgan
>> University of Washington
>> damor..._at_x.washington.edu
>> (replace x with u to respond)
>> Puget Sound Oracle Users Groupwww.psoug.org
>
> I bet there won't be something like:
> SELECT * EXCEPT (col1, col2, col2) -- select all columns except
> (col1, col2, col2)
> FROM table_with_43_columns; -- which I'd love, but yet have to live
> without it:)
I am sympathetic but definitely with Michel on this. If they built it
... it would be a mistake waiting to happen.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Fri Mar 23 2007 - 17:43:41 CDT
