Drop Table Oracle Database Tutorial Example

How To Drop Table In Oracle Database Tutorial Example

Run MS-DOS command prompt then copy & paste the below code to drop a table in Oracle Database Server Tutorial Example

-- connect as TUTORIAL
-- i am using sqlplus as client. you can use anything as you like.
 
   DROP TABLE test PURGE;
   -- For Oracle 10g and higher version

   -- DROP TABLE test;
   -- For Oracle 9i and lower version
      -- that's it!! Oracle database table "test" has been droped
      -- is comment in Oracle
      -- in fact it is comment in MSSQL and MySQL as well
   

How To Drop Table In Oracle Database Tutorial Example - Result in MS-DOS SQLPLUS Client Tools

 

Related Tutorial Examples

  1. How To Truncate Table In Oracle Database Tutorial Example
  2. How To Insert Row In Oracle Database Table Tutorial Example
  3. How To Insert Specific Columns In Oracle Database Tutorial Example
  4. How To Select Data From Oracle Database Table Tutorial Example
  5. How To Select Specific Rows From Oracle Database Tutorial Example
  6. MySQL IFNULL() Function Boolean Example
  7. MySQL TRUNCATE TABLE Example
  8. 19 Examples to Learn MySQL
  9. 20 Steps to Learn CakePHP by Example
  10. UNIX Command Example: Display File Last Modified Information

No comments:

Post a Comment

leave your comments here..