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
Oracle awrinfo sql Tips
This script will output general Automatic Workload Repository(AWR) information such as the size, data distribution, etc. in AWR and SYSAUX. The intended use of this script is for diagnosing abnormalities in AWR and not for diagnosing issues in the database instance. Please look at addmrpt.sql and awrrpt.sql for diagnosing database issues.