I want to generate a view
through a select
with the code below, but it does not work, what can it be?
$row[0]
contains "select col1, col2, col3, col4, col5 from tabela1"
$select= oci_parse($ora_conexao, 'SELECT * FROM TABELA');
oci_execute($select);
while (($qrow = oci_fetch_row($select)) != false) {
$arrData[] = $row[0].'<br />';
}
$var = implode('',$arrData);
//--> cria temp view
$view = oci_parse($ora_conexao,"CREATE OR REPLACE FORCE VIEW \"TD_ADMIN\".\"view1\" (\"col1\", \"col2\", \"col3\", \"col4\", \"col5\") AS $var");
oci_execute($view);