frequently ask ? : Computers : Programming : Languages : PHP : Database Backed Sites : Oracle

+ Search
Add Entry AlertManage Folder Edit Entry Add page to
Did You Find This Entry Useful?

4 of 9 people (44%) answered Yes
Recently 4 of 9 people (44%) answered Yes


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) 
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.