If you are on 10g or later and the recycle bin feature is turned on, you can use the FLASHBACK TABLE x TO BEFORE DROP command, where x is the name of the table. If it is not there, or the recycle bin feature is not available, you will have to restore the table from a backup.
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
Use SQLLoader utility of Oracle
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.
the full form of 10g in oracle is g=grid computing
In Oracle 10g, 'g' stands for grid computing. For more details about Oracle 10g and overall Oracle DB please refer the following link:http://en.wikipedia.org/wiki/Oracle_Database
Oracle 10g's commands are internal; they have nothing to do with what platform it is running on.
get data of particular rows from the table. Criteria can be used to select the rows retrived
what is difference between oracle 9i and oracle 10g what is difference between oracle 9i and oracle 10g What is the Full form of "i" in Oracle 9i What is the Full form of "g" in Oracle 10g ans =the oracle 9i the "i" is stands for internet and oracle 10g the " g" stands for grid and new version of oracle 11g was launch in 2007 it provided the special feature rather 8i ,9i other it have a RAC, and network security etc. and good for organization purpose .
Go to Oracle's webpage for a free download of Oracle 10g for Windows 7, and every other software need you have from Oracle! Oracle will help solve all your software needs!
G signifies "Grid Computing"... With the release of Oracle 10g in 2003, Oracle changed the suffix in their previous release version; from 9i to 10g... 'I' stands for Internet...this was done as a marketing effort in order to show Oracle's move towards Grid Computing... Purely a marketing strategy...
oracleDB
there is no books in oracle forms 10g in oracle publication but they have student Gide which is not good for certification exam u should try Otn forums for help......