CODEWITHSUNDEEP
sqloracle-database
rhys_stubbs
rhys_stubbs

Reputation: 598

Oracle SQL Syntax Error - missing comma

Below is a line of one of my insert statements, it keeps throwing a missing comma error - however Im either blind as a bat or going stupid?!

INSERT INTO barrister (barrister_id,firstname,surname,telephone,email_address)
    VALUES (NEXT VALUE FOR sq_barrister, 'John', 'Smith',
            '01392345465', '[email protected]');

Upvotes: 0

Views: 222

Answers (1)

S. Rojak
S. Rojak

Reputation: 454

Raul is right. NEXT VALUE FOR is from SQL Server. In Oracle, use

sq_barrister.nextval

Upvotes: 3

Related Questions