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' } );