Oracle Basic SQL 011 Study Tips
Delete the same contents.
Oracle Basic SQL 010 Study Tips
Multi-table association update, Please use merge into or update via VIEW.
MERGE INTO Tips.
merge into xxx
using ()
on ()
when matched then
update ...
when not matched then
insert ... values ...
Oracle Basic SQL 009 Study Tips
Oracle Basic SQL 008 Study Tips
INSERT default value.
Use view to protect default value.
Oracle Basic SQL 007 Study Tips
List department name with only department name and no employees in it.
eg. department_id: 170 (Manufacturing) there is NOT employees in this department.
Oracle Basic SQL 006 Study Tips
list employee infor and list the manager’s name.
Oracle Basic SQL 005 Study Tips
Oracle Basic SQL 004 Study Tips
Oracle Basic SQL 003 Study Tips
HASH JOIN SEMI
Oracle Basic SQL 002 Study Tips
Oracle Basic SQL 001 Study Tips
null first/null last
case when