vb6连oracle为何不能delete ?

Question

               Dim conn As adodb.Connection
              Set conn = New adodb.Connection
               conn.ConnectionString = "File Name=oracle.udl;"
               conn.Open 'udl
               sstr1 = "delete * from realtime_status"
               conn.Execute sstr1
               
                              Adodc1.ConnectionString = "File Name=oracle.udl;"
     
               Adodc1.RecordSource = sstr1
               Adodc1.Refresh
连续用这两种方法delete表realtime_status 均不成功，但如果是insert 是可以的。请问是什么原因，要怎么修改？SOS

Answer 1

delete from realtime_status -> "delete from realtime_status"
标准的删除语句不能包含*号.