GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages


Manual Reference Pages  -  DATA::OBJECTDRIVER::DRIVER::DBD::ORACLE (3)

.ds Aq ’

NAME

Data::ObjectDriver::Driver::DBD::Oracle - Oracle Driver for Data::ObjectDriver

CONTENTS

DESCRIPTION

This module overrides methods of the Data::ObjectDriver::Driver::DBD module with Oracle specific implementation.

NOTES

Oracle doesn’t support auto-increment, so before you use this feature, you should create a sequence and a trigger to work with it.

For example, you want field ID in table WINES be auto-increment, then create:



    -- Create sequence
    CREATE SEQUENCE WINES_ID_SEQ
    MINVALUE 1
    MAXVALUE 999999999999999999999999999
    START WITH 1
    INCREMENT BY 1
    NOCACHE;

    -- Create trigger
    CREATE OR REPLACE TRIGGER WINES_ID_TR
      BEFORE INSERT ON WINES
      FOR EACH ROW
    BEGIN
      SELECT WINES_ID_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
    END;



LICENSE

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

AUTHOR & COPYRIGHT

This module is copyright (c) 2009 Xiaoou Wu <xiaoou.wu@oracle.com>. All rights reserved.
Search for    or go to Top of page |  Section 3 |  Main Index


perl v5.20.3 DATA::OBJECTDRIVER::DRIVER::DBD::ORACLE (3) 2016-01-14

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with manServer 1.07.