how can i get the auto generated number in oracle database

[fy_chongch]

i can't get the generated seq number of the oracle, how can i get the generated auto number for insert data into table

$req = "select xxx.nextval from dual";
$stm = OCIParse ($con, $req);
OCIExecute($stm, OCI_DEFAULT);
while (OCIFetch($stm)){
$x = OCIResult ($stm, "???");

as i know dual is a build in table in oracle. i can't get the value for xxxx.nextval. & what should i write for ???? because the dual doesn't have any any column name. Any one can help me?thanks😕

[sdjensen]

There are two ways of doing this:

$req = "select xxx.nextval from dual"; 
$stm = OCIParse ($con, $req); 
OCIExecute($stm, OCI_DEFAULT); 
while (OCIFetch($stm)){ 
      $x = OCIResult($stm,1);
}

or directly in your insert statement like this

$query = "INSERT INTO tasks (tname,tdesc,tid) VALUES ('$tname','$tdesc', wh1.tasks_seq.nextval )";