Double DELETE Command *

Dúvidas, dicas e truques de SQL, Select, Update, Delete, cláusulas, operações com joins, Funções em SQLs, etc
Post Reply
karinetakayama
Rank: Estagiário Júnior
Rank: Estagiário Júnior
Posts: 2
Joined: Thu, 18 Aug 2005 10:13 am
Location: Osasco / SP

I have a question ..
in the delete command, if I put as below, will it work normally?
I know that it is not necessary to put the astereus, but I would like to know if it works so it works

Select all

DELETE * FROM tabela WHERE codigo=3;
grata and help me please: LOL :: Roll:
User avatar
dr_gori
Moderador
Moderador
Posts: 5024
Joined: Mon, 03 May 2004 3:08 pm
Location: Portland, OR USA
Contact:
Thomas F. G

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

Just test!

Select all

tapi:SCOTT> delete * from t; 
delete * from t 
       * 
ERROR at line 1: 
ORA-00903: invalid table name 
 
 
tapi:SCOTT>  
That is, it does not work!
karinetakayama
Rank: Estagiário Júnior
Rank: Estagiário Júnior
Posts: 2
Joined: Thu, 18 Aug 2005 10:13 am
Location: Osasco / SP

muito thank you
hhehehe

and I have not tested because without oracle, thanks mesmo

but what a pity that did not work hunff
Post Reply
  • Information
  • Who is online

    Users browsing this forum: Google [Bot] and 16 guests