Oracle Version Info

Release Number Format To understand the release nomenclature used by Oracle, examine the following example of an Oracle Database server labeled “Release 10.1.0.2.3”. 10 – Major Database Release Number The first digit is the most general identifier. It represents a…

Listing tables in DB

User tables select distinct owner from dba_objects; If you logged in as Normal User without DBA permission you may uses the following command to see your own schema’s all tables and views. select * from tab; it will show all…