my $item = db::Inventory::Item->retrieve( 15 );
if( $item ) {
$item->quantity( 15 );
}
####
-- Oracle:
INSERT INTO my_table
VALUES( my_sequence.nextval, 'Some Value' );
-- Postgres:
INSERT INTO my_table
VALUES( nextval( 'my_sequence' ), 'Some Value' );
##
##
--MySQL
INSERT INTO my_table( seq_field, val_field )
VALUES (NULL, 'Some Value');
SELECT LAST_INSERT_ID();
-- SQL Server
INSERT INTO my_table( val_field )
VALUES ( 'Some Value' );
SELECT SCOPE_IDENTITY();
##
##
my $newRecord = db::Table->create( { val_field => 'Some Value' } );