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:[EMAIL PROTECTED]]
> Gesendet: Dienstag, 10. Juli 2001 04:36
> An: [EMAIL PROTECTED]
> 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
>
>
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
