Deleting a table in oracle 10g

Whenever you have created a table and in u want to delete a particular row from the table the you must use the following command.

There are several step regarding to delete a row from the table.



Step 1: Select the row that you want to delete.

Step 2: now that particular row from the table.

Delete command:

SELECT * FROM TABLE NAME;
Row is selected
DELETE FROM TABLE NAME;

Row deleted

Example:



The selected row is deleted .

Read more articles related oracle click here