Skip to content

Oracle errors in Express Edition 21 #31

@RichardJECooke

Description

@RichardJECooke

https://github.com/lerocha/chinook-database/blob/master/ChinookDatabase/DataSources/Chinook_Oracle.sql

SQL Error [900] [42000]: ORA-00900: invalid SQL statement

  Error : 900, Position : 0, Sql = conn chinook/p4ssw0rd


/*******************************************************************************
   Create Tables
********************************************************************************/
CREATE TABLE Album
(
    AlbumId NUMBER NOT NULL,
    Title VARCHAR2(160) NOT NULL,
    ArtistId NUMBER NOT NULL,
    CONSTRAINT PK_Album PRIMARY KEY  (AlbumId)
), OriginalSql = conn chinook/p4ssw0rd


/*******************************************************************************
   Create Tables
********************************************************************************/
CREATE TABLE Album
(
    AlbumId NUMBER NOT NULL,
    Title VARCHAR2(160) NOT NULL,
    ArtistId NUMBER NOT NULL,
    CONSTRAINT PK_Album PRIMARY KEY  (AlbumId)
), Error Msg = ORA-00900: invalid SQL statement

  ORA-00900: invalid SQL statement

Metadata

Metadata

Assignees

Labels

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions