Spital

an anonymous user · December 06, 2021 · SQL
CREATE TABLE Pacienti (
  CNP_P NUMBER(13) PRIMARY KEY,
  Nume TEXT NOT NULL,
  Prenume TEXT NOT NULL,
  Data_nasterii date not NULL,
  Sex VARCHAR2(1) NOT null
);

INSERT INTO students VALUES (333222111, 'Ryan', 'Maricel', '12.12.1912', 'M');
INSERT INTO students VALUES (222333111, 'Popescu', 'Joanna', '31.04.1987', 'F');

SELECT * FROM Pacienti WHERE Sex = 'F';

Comments

Please sign up or log in to contribute to the discussion.