|
Unix VPS
Support
FAQ
Network
Miscellaneous
|
| Data::ObjectDriver::Driver::DBD::Oracle(3) | User Contributed Perl Documentation | Data::ObjectDriver::Driver::DBD::Oracle(3) |
NAME
Data::ObjectDriver::Driver::DBD::Oracle - Oracle Driver for Data::ObjectDriverDESCRIPTION
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.| 2020-10-29 | perl v5.32.1 |
Visit the GSP FreeBSD Man Page Interface.
Output converted with ManDoc.