Answers for "auto increment id oragle"

SQL
0

typeorm auto increment id

import {Entity, PrimaryGeneratedColumn} from 'typeorm';

@Entity()
export class SomeWhat{

    @PrimaryGeneratedColumn('increment')
    public id: number;
....
Posted by: Guest on November-04-2020
0

oracle create table auto generated primary key

-- For oracle 12c or later 
-- auto inc
create table t1 (
    c1 NUMBER GENERATED by default on null as IDENTITY,
    c2 VARCHAR2(10)
    );
-- More options for initial value and increment value
create table t1 (
    c1 NUMBER GENERATED ALWAYS as IDENTITY(START with 1 INCREMENT by 1),
    c2 VARCHAR2(10)
    );
Posted by: Guest on May-04-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language