Drop moves a table to recycle bin, it remove the table and all data entries. If the purge clause is used with drop statement invalidates the dependent objects and remove all privileges on the table all data’s and objects like view, sequence, synonyms etc.. is deleted from table. Using FLASHBACK statementwe can restore the dropped table from recycle bin we will see later in detail about flashback statement.
Syntax: - DROP TABLE tablename; or DROP TABLE tablename PURGE;
Ex: - DROP TABLE student; or DROP TABLE student PURGE;
This is dummy text. It is not meant to be read. Accordingly, it is difficult to figure out when to end it. But then, this is dummy text. It is not meant to be read. Period.
ConversionConversion EmoticonEmoticon