AW: [PHP] Oracle question
| From: | Sebastian Stadtlich | Date: | Tue, 10 Jul 2001 09:31:32 +0000 |
| Subject: | AW: [PHP] Oracle question | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-57118@lists.php.net to get a copy of this message | ||
oracle does not have an autoincrement.
it has the more powerfull concept of TRIGGERS
unfortunatelly you have to write them in pl/sql or java...
have a look on the net for oracle trigger tutorial or
you can
find a super oracle-feature-documentation here :
http://conf.php.net/oci2
http://conf.php.net/pres/slides/oci/paper.txt
which features a small non-trigger-work-around
sebastian
> -----Ursprüngliche Nachricht-----
> Von: Duy B [mailto:ngo_duy@fmail.vnn.vn]
> Gesendet: Dienstag, 10. Juli 2001 04:36
> An: php-general@lists.php.net
> Betreff: [PHP] Oracle question
>
>
> Dear all,
> If i want to use id field in Oracle database, how can i do?
> For example, in MySQL
> create table test (
> id int not null auto-increment primary key,
> ten char(10));
>
> So that, when i insert a new row into MySQL database, id
> increases by 1.
>
> But in Oracle i couldn't use as that.
> Somebody could help me.
> Thanks you all,
> BaoDuy
>
>
>
>