⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 appendixc_oracle_attendancetable_data.txt

📁 sql的原代码可以供学习sql的人提供好的学习材料
💻 TXT
字号:
INSERT INTO Attendance 
(
  LocationId,
  MeetingDate,
  MemberAttended,
  MemberId
)
VALUES
 ( 
  2,
  '1 Jan 2004',
  'Y',
  1
 );

INSERT INTO Attendance 
(
  LocationId,
  MeetingDate,
  MemberAttended,
  MemberId
)
VALUES
 ( 
  2,
  '1 Jan 2004',
  'N',
  2
 );

INSERT INTO Attendance 
(
  LocationId,
  MeetingDate,
  MemberAttended,
  MemberId
)
VALUES
 ( 
  2,
  '1 Jan 2004',
  'Y',
  3
 );

INSERT INTO Attendance 
(
  LocationId,
  MeetingDate,
  MemberAttended,
  MemberId
)
VALUES
 ( 
  2,
  '1 Jan 2004',
  'N',
  4
 );

INSERT INTO Attendance 
(
  LocationId,
  MeetingDate,
  MemberAttended,
  MemberId
)
VALUES
 ( 
  2,
  '1 Jan 2004',
  'Y',
  5
 );

INSERT INTO Attendance 
(
  LocationId,
  MeetingDate,
  MemberAttended,
  MemberId
)
VALUES
 ( 
  2,
  '1 Jan 2004',
  'Y',
  6
 );

INSERT INTO Attendance 
(
  LocationId,
  MeetingDate,
  MemberAttended,
  MemberId
)
VALUES
 ( 
  1,
  '1 Mar 2004',
  'Y',
  1
 );

INSERT INTO Attendance 
(
  LocationId,
  MeetingDate,
  MemberAttended,
  MemberId
)
VALUES
 ( 
  1,
  '1 Mar 2004',
  'N',
  2
 );

INSERT INTO Attendance 
(
  LocationId,
  MeetingDate,
  MemberAttended,
  MemberId
)
VALUES
 ( 
  1,
  '1 Mar 2004',
  'Y',
  3
 );

INSERT INTO Attendance 
(
  LocationId,
  MeetingDate,
  MemberAttended,
  MemberId
)
VALUES
 ( 
  1,
  '1 Mar 2004',
  'Y',
  4
 );

INSERT INTO Attendance 
(
  LocationId,
  MeetingDate,
  MemberAttended,
  MemberId
)
VALUES
 ( 
  1,
  '1 Mar 2004',  
  'N',
  5
 );

INSERT INTO Attendance 
(
  LocationId,
  MeetingDate,
  MemberAttended,
  MemberId
)
VALUES
 ( 
  1,
  '1 Mar 2004',
  'N',
  6
 );

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -