SQL & PL/SQL

Hello guys,

Can I use truncate with where clause in the same statement.


For ex:

TRUNCATE TABLE my_table WHERE id < 500;

If not, what you recommend me in order to decrase the High Water Mark level?


By the way

select * from v$version;

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
"CORE 11.2.0.1.0 Production"
TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
>

Thanks a lot.

Edited by: 970992 on 13.Ara.2012 11:14