In Oracle , SQL platform ,
is there any Delete (DML) statement with the following syntax ----
Delete from <Table_Name> All ;
If it exists can anybody tell me how it works and how it is different from
Delete from <Table_Name> ;
Also in Teradata , SQL platform ,
Are the same applicable ?
In oracle the is no command like "Delete from <Table_Name> All ;"
I guess you want to flush the data in a table.
You can use the command "Truncate table <Table_Name> ;"
"Delete from <Table_Name> ;" can be rolled back but "Truncate table <Table_Name> ;" can not be rolled back. Once data is gone, it's gone.
Basically, a truncate statement resets the high water mark to its initial position. That's how it works.
Hope this helps.