NAME

DBIx::IO::OracleIO - DBIx::IO driver for Oracle

DESCRIPTION

See DBIx::IO.

METHOD DETAILS

See superclass DBIx::IO for more

sequence_name

$sequence_name = $io->sequence_name([$sequence_name]);

Get/set the name of the sequence that generates key values for inserts. Defaults to the name of the table prepended with "SEQ_".

key_nextval

$next_seq_val = $io->key_nextval([$seq_name]);

Returns the next value in the Oracle sequence object named $seq_name or the table name prepended with "SEQ_" All sequence statement handles are cached per $dbh for performance reasons. A new $sth will be prepared unless the object that calls this method has previously called it with the same sequence request.

Returns undef if error.

existing_table_names

$sorted_arrayref = DBIx::IO::OracleIO->existing_table_names([$dbh]);

Return a sorted arrayref of table names found in the data dictionary.

Class or object method. $dbh is required if called as a class method.

Return undef if db error.

is_datetime

$bool = $io->is_datetime($column_name);

Determine if $column_name is of a datetime type.

is_date

$bool = $io->is_date($column_name);

Determine if $column_name is of a date type.

is_char

$bool = $io->is_char($column_name);

Determine if $column_name is of a character type.

limit

$sql = $io->limit($sql,$limit);

Modify the given $sql to return a limited set of records.

lc_func

$function = $io->lc_func($column);

Apply the function for modifying $column to lower case.

BUGS

No known bugs.

SEE ALSO

DBIx::IO::Table, DBIx::IO::Search, DBIx::IO, DBIx::IO::OracleLIB

AUTHOR

Reed Sandberg, <reed_sandberg Ó’ yahoo>

COPYRIGHT AND LICENSE

Copyright (C) 2000-2008 Reed Sandberg

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

The full text of the license can be found in the LICENSE file included with this module.

cpanm DBIx::IO

perl -MCPAN -e shell
install DBIx::IO