danieltnaves

Anotações sobre Scrum (prints em anexo).

danieltnaves

CREATE TABLE Type(
    Type VARCHAR2(20) Primary Key,
    Fee number);

CREATE TABLE Member(
    MemberID NUMBER Primary Key,
    LastName VARCHAR2(20),
    FirstName VARCHAR2(20),
    MemberType VARCHAR2(20) constraint fk1_member References type(type),
    Phone VARCHAR2(20), Handicap NUMBER, JoinDate DATE, Coach NUMBER, Team

danieltnaves

-- Selecting Rows Where the Case of a Text Value Is Not Important
SELECT *
FROM MEMBER M
WHERE UPPER(M.MEMBERTYPE) = 'SENIOR'

-- Finding the Members with No Value for MemberType
SELECT * 
FROM MEMBER M
WHERE M.MEMBERTYPE IS NULL