Delphi32.com -- The Premier Source for Delphi Developers!

Some useful tables/views/synonyms

December 7, 1997

There are A LOT of system tables in an Oracle Database. This section just picks a few that are interesting as seen from the application developer's point of view.

Keep in mind that not all tables are accessible from all users. Some require that DBA rights are granted. So, in no particular order:

Name	Description
DUAL	Dual is a very simple table with only one column and one row. This is the way to get to different variables in Oracle, such as the current user (`select user from dual`), return value of a function (`select upper('lowercase') from dual`) and what have you.
DBA_USERS	This is handy if you need to see information on users in the database, such as default tablespaces, or whether their login is authenticated by the network or the server itself.
V$PARAMETER	Here you can see the current parameter settings in the database. You CANNOT change the values from here!. Use SQLDBA for that, or modify the parameter file `initorcl.ora` and restart the database.
TAB	Quick overview of accessible tables/views
IND	Quick overview of accessible indexes
ALL_xx	these tables contain information on all available objects for this user. This includes everything, right down to source code for PL/SQL procedures
V$SESSION	Contains all active sessions. Nice to see who's on the system

Hits/month	2,500,000+
Downloads (Since May 2000)	7,393,709
Total Files	6,023
Forum msgs	7,670
Articles/FAQs	70+/900+

Kylix

Books

Top Selling Software at Amazon

Site Search: