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

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

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

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