Re: partiioning option not worth it?

On Sat, 23 Feb 2002, kboulton_at_ntlworld.com wrote:
>
> True, but cut and paste is the most efficient code reuse mechanism
> I've ever encountered.

#!/bin/ksh

NewPartitionName=$1

sqlplus user/pass_at_blah <<EOF
create table $NewPartitionName
(
....
)

create or replace view blah as

    select ...
    from ...

    UNION     select ...
    from ...

    UNION     select ...
    from $NewPartitionName
;

EOF Does this do better than cut and paste? :-)

-- 
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.