add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE User_T(
IdUser NUMBER(10,0) NOT NULL,
FirstName VARCHAR2(100) NOT NULL,
LastName VARCHAR(100) NOT NULL,
Email VARCHAR(50) NOT NULL,
UserName VARCHAR(30) NOT NULL UNIQUE,
UserPassword VARCHAR2(30) NOT NULL,
CreatedAt VARCHAR2(30),
UpdatedAt VARCHAR(30),
Enabled CHAR(10), -- Remove the CHECK
CONSTRAINT IdUser_PK PRIMARY KEY(IdUser)
);
DROP TABLE user_t;
CREATE TABLE User_T(
IdUser NUMBER(10,0) NOT NULL,
FirstName VARCHAR2(100) NOT NULL,
LastName VARCHAR(100) NOT NULL,
Email VARCHAR(50) NOT NULL,
UserName VARCHAR(30) NOT NULL UNIQUE,
UserPassword VARCHAR2(30) NOT NULL,
CreatedAt VARCHAR2(30),
UpdatedAt VARCHAR(30),
Enabled CHAR(10) CHECK (Enabled IN ('Foo ', 'Bar ')),
CONSTRAINT IdUser_PK PRIMARY KEY(IdUser)
);