AppleGrew
AppleGrew

Reputation: 9574

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.

Upvotes: 1

Views: 1244

Answers (1)

Egor Skriptunoff
Egor Skriptunoff

Reputation: 23757

FROM keyword and WHERE clause are optional.

Upvotes: 3

Related Questions