<?php

$tns = "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxxxx)(PORT=1521)))(CONNECT_DATA=(SID=xxxx)))";

$db_username = "xxxx";
$db_password = "xxxxx";


try{
    $conn = new PDO("oci:dbname=".$tns,$db_username,$db_password);
	$sql = ".............'";
	//$result = $conn->query($sql);
	foreach ($conn->query($sql) as $row) {
		print_r($row);
	}
	$conn = null;
}catch(PDOException $e){
    echo ($e->getMessage());
}

?>