Entry

How can I query v$ tables (e.g. v$database) via PHP?

May 9th, 2004 03:11
Eugene Smirnoff, Eyzen Medina, Huseyin Bilgen,

select table_name from user_tables;  --User Tables
select table_name from All_tables;  --All Database Tables

In Oracle you can work with internal objects with SQL

You have to take a look to oracle Data Definition Language (DDL) 
Documentation.

Eyzen

You should set permissions for these tables for your user (you may
use corresponding views such as v_$database) and use schema name (e.g. 
sys.table_name)

Eugene