Search code examples
plsqloracle11gtemp-tables

What does `delete <table name>` in PLSQL code mean?


I have a PLSQL code with the following line of code.

delete my_table;

Where my_table is a Global Temporary Table. I am guessing the above code means, delete all rows from the table. However, I am unable to google out any result.


Solution

  • FROM keyword and WHERE clause are optional.