SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

delete * from <table>

580717Jun 23 2011 — edited Jun 24 2011

hi,

Is it possible to use

delete * from <table_name>;

when i tried it gave me error

delete * from temp
Error at line 1
ORA-00903: invalid table name

but on page its shown as possible

http://psoug.org/definition/DELETE.htm

so whats true.

This post has been answered by William Robertson on Jun 24 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 22 2011

Added on Jun 23 2011

6 comments

744 views