NAME

SPOPS::Import::DBI::TableTransform::Oracle - Table transformations for Oracle

SYNOPSIS

my $table = qq/
  CREATE TABLE blah ( id %%INCREMENT%% primary key,
                      name varchar(50) )
/;
my $transformer = SPOPS::Import::DBI::TableTransform->new( 'oracle' );
$transformer->increment( \$table );
print $table;

# Output:
# CREATE TABLE blah ( id INT NOT NULL primary key,
#                     name varchar(50) )

DESCRIPTION

Oracle-specific type conversions for the auto-increment and other field types.

METHODS

increment

Returns 'INT NOT NULL'

increment_type

Returns 'INT'

datetime

Returns 'DATE'

BUGS

None known.

TO DO

Add hook for extra statement

Since Oracle supports a sequence-based increment type, think about adding a hook for an extra statement to be registered.

SEE ALSO

SPOPS::Import::DBI::TableTransform

COPYRIGHT

Copyright (c) 2002 intes.net, inc.. All rights reserved.

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

AUTHORS

Chris Winters <chris@cwinters.com>