Doubt DELETE Command *

Dúvidas, dicas e truques de SQL, Select, Update, Delete, cláusulas, operações com joins, Funções em SQLs, etc
  

Poston Thu, 18 Aug 2005 10:22 am

I'm with a doubt
in the delete command, if I put as below, will operate normally?
know q is not necessary to place the star, however I wonder if mesmo so it works DELETE * FROM table WHERE code = 3;

grateful and help me please: lol:: roll:
karinetakayama
Location: Osasco / SP

Poston Thu, 18 Aug 2005 10:30 am

Just test!

Code: Select all
tapi:SCOTT> delete * from t;
delete * from t
       *
ERROR at line 1:
ORA-00903: invalid table name


tapi:SCOTT>
IE DOES NOT WORK!
dr_gori
Location: Portland, OR USA

Thomas F. G

Você já respondeu a dúvida de alguém hoje?
http://glufke.net/oracle/search.php?search_id=unanswered

Poston Fri, 19 Aug 2005 8:57 am

muito Obrigadaaa Hhehehe and I have not tested porque without oracle, thanks mesmo but q q penalty não worked hunff
karinetakayama
Location: Osasco / SP


  • See also
    Replies
    Views
    Last Post


Return to SQL

Who is online

Users browsing this forum: No registered users and 2 guests