I am trying to create a table in my database, however it is giving error of invalid data types
Script from my table:
create table Venda
(
cod_Venda number(5)not null,
DataVenda DATE,
Hora TIME,
cod_Comanda number(5)not null,
constraint PK_cod_Venda_Venda PRIMARY KEY(cod_Venda)
);
Error:
Command Line Error: 486 Column: 8 Error Reporting - SQL Error: ORA-00902: Invalid data type 00902. 00000 - "invalid datatype" * Cause:
* Action: commit.
I'm using SQL Developer. Could someone help me?