I have created sequence in database like,
CREATE SEQUENCE seq INCREMENT BY 1;
How can i assign the current value of seq in $t;
<?php
$t=?;
?>
views:
71answers:
2
+1
A:
Run this query and fetch the result of it:
SELECT seq.CURRVAL FROM dual
Bill Karwin
2010-01-23 23:44:54
Won't work unless the session has previously called seq.NEXTVAL.
Jeffrey Kemp
2010-01-25 02:45:06
@Jeffrey: Yes, good point.
Bill Karwin
2010-01-25 06:15:27
+1
A:
If you want the next value from the sequence you would run the sql statement below and fetch back the results of the myseq column.
select seq.nextval myseq
from dual;
Dougman
2010-01-24 19:19:47