Problem with tables

Scripts Diversos para o Oracle SQL*Plus. (Relacionado a ferramenta Oracle SQL*Plus, para questões de SQL, usar o forum SQL)
Post Reply
dham
Rank: Estagiário Pleno
Rank: Estagiário Pleno
Posts: 4
Joined: Tue, 09 Mar 2010 2:11 pm
Location: Apucarana - Paraná

Good evening

I created some tables and I can do the insertion of the data normally however when I try to delete what I have in the table it reports that the table name is wrong.

Can anyone give help?

Select all

delete * from cidade; 
 
ORA-00903: invalid table name 
 
SQL> describe cidade 
 Name                                                                                                              Null?    Type 
 --------------------------------------------------------------------------------------------------- 
 CD_CIDADE                                                                                                         NOT NULL NUMBER(4) 
 NR_DDD                                                                                                            NOT NULL NUMBER(2) 
 SG_ESTADO                                                                                                         NOT NULL VARCHAR2(2) 
 NM_CIDADE                                                                                                         NOT NULL VARCHAR2(40)
victorhugomuniz
Moderador
Moderador
Posts: 1396
Joined: Fri, 01 Feb 2008 2:06 pm
Location: Rio de Janeiro - RJ
Contact:
:D

Select all

delete from cidade
dham
Rank: Estagiário Pleno
Rank: Estagiário Pleno
Posts: 4
Joined: Tue, 09 Mar 2010 2:11 pm
Location: Apucarana - Paraná

: Oops:

Thanks.
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 3 guests