EMPLOYEE_ID |
FIRST_NAME |
LAST_NAME |
HIRE_DATE |
SALARY |
$nativ_spoj = OCILogon("HR","HR");
$stmt = OCIParse($nativ_spoj, "SELECT * FROM employees");
OCIDefineByName($stmt,"EMPLOYEE_ID",&$EMPLOYEE_ID);
OCIDefineByName($stmt,"FIRST_NAME",&$FIRST_NAME);
OCIDefineByName($stmt,"LAST_NAME",&$LAST_NAME);
OCIDefineByName($stmt,"HIRE_DATE",&$HIRE_DATE);
OCIDefineByName($stmt,"SALARY",&$SALARY);
OCIExecute($stmt);
echo "";
while (OCIFetch($stmt))
{
echo "
";
echo "".$EMPLOYEE_ID." | ";
echo "".$FIRST_NAME." | ";
echo "".$LAST_NAME." | ";
echo "".$HIRE_DATE." | ";
echo "".$SALARY." | ";
echo "
";
}
OCIFreeStatement($stmt);
OCILogoff($nativ_spoj);
?>