Invalid Data Types

1

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?

    
asked by anonymous 17.10.2016 / 00:18

1 answer

1

There is no Time data type in Oracle. The date fields store century, day, month, year, hours, minutes, and seconds.

    
24.10.2016 / 18:55