?? chapter2_oracle_data_modifications.txt
字號:
UPDATE MemberDetails
SET
Street = '45 Upper Road',
City = 'New Town',
State = 'New State',
ZipCode = '99112'
WHERE MemberId = 4;
UPDATE MemberDetails
SET City = 'Orange Town'
WHERE City = 'Big Apple City';
UPDATE Location SET City = 'Orange Town' WHERE City = 'Big Apple City';
UPDATE MemberDetails SET LastName = 'Tell' WHERE MemberId = 3;
UPDATE MemberDetails SET Street = 'Newish Lane' WHERE Street = 'New Lane'
AND City = 'Orange Town';
UPDATE MemberDetails
SET State = 'Mega State'
WHERE
State = 'Small State'
OR
State = 'Stateside';
UPDATE Location
SET State = 'Mega State'
WHERE
State = 'Small State'
OR
State = 'Stateside';
DELETE FROM Attendance WHERE MemberId = 3;
DELETE FROM FavCategory WHERE MemberId = 3;
DELETE FROM MemberDetails WHERE MemberId = 3;
COMMIT;
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -