on 8/6/01 5:33 PM, Rankin, Randy at [EMAIL PROTECTED] wrote:

> When I execute this query, the server returns the following error.
> Warning: OCIStmtExecute: ORA-00942: table or view does not exist in
> /usr/local/apache/htdocs/oracle/oraprod.php on line 17
> My suspicion is that PHP thinks that the '$' in the table name is the
> beginning of a variable. Does anyone know how to get around this so that I
> can execute a query with a table name like v$instance?

Sure.  Either use single quotes:

$query = 'SELECT instance_name, host_name FROM v$instance';

Or escape the $:

$query = "SELECT instance_name, host_name FROM v\$instance";



Paul Burney

Paul Burney
Webmaster && Open Source Developer
(310) 825-8365

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to