Question

请教，ORACLE的删除语句怎么写？是DELETE * FROMTABLE吗

Answer 1

truncate table [tablename]这个速度比较快
delete from [tablename]这个是常规删除

Answer 2

delete from table where .....;

Answer 3

delete table where *********

Answer 4

不用那个 *