Skip to Main Content
Forums

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!

ORA-30560: Delete problem With Sample keyword.

Satyaki_DeFeb 28 2007 — edited Mar 1 2007
Hi!
I've a problem in delete statement. The script is below ---
SQL> delete from ( select * from ggg);

16 rows deleted.
It is working. but, when i try to run this delete statement with sample keyword - it is giving me error. Is there anyway to use this samplekeyword with delete statement?
SQL> delete from ( select * from ggg sample(75)); --showing error
Regards.

Satyaki De.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 29 2007
Added on Feb 28 2007
34 comments
1,914 views