Use the Describe Command
to tell the future
select * from v$version where banner like 'oracle%';
Use the Oracle revoke command Example: revoke execute on procedure from user;
The oracle 10g and oracle 8i there is a minor difference that is oracle 8i doesn't support flash back command once we drop the table in database the message is table dropped but we can use flashback command we can retrieve the drop table once in database
This is a presentation area in the OBIEE software. In this catalog you can alter system names to user friendly names for your end reporting.
There are many companies and websites that offer the oracle 10g documentation. The best way to obtain the Oracle 10g documentation is through the official Oracle website.
You can obtain information about collections in Java online at the Java section of the Oracle Docs website. Alternatively, you can also find this information at the Wikipedia. Once on the website, type "Java collections framework" into the search field at the top of the page and press enter to bring up the information.
On the Oracle forums, one can find information pertaining to Oracle software. There are questions, answers, and discussions about the use of the software as well as troubleshooting information.
CRS is Oracle's Cluster Ready Services. For more information research Oracle Clusterware.
Some of the functions for the alter table command in Oracle include renaming columns or rows, adding columns or rows and marking items as being read only.
Try to browse oracle's site.
SELECT, overall, I would view as most important.