How to create the Scott Oracle Database Demo Schema?

https://www.youtube.com/watch?v=yi7N4BXNJfc

How to create the Scott Demo Database Schema?

Scott schema is the most famous oracle database demo schema that is available since 1990 !. Scott is a database user used for demonstration purposes containing the famous EMP, DEPT, BONUS and SALGRADE tables.This account was named after Bruce Scott (co-author and co-architect of Oracle v1 to v3) and the password was the name of his daughter's cat, Tiger. … Continue reading How to create the Scott Demo Database Schema?

Installing Oracle Sample Schemas (19.3)

In this post, I'm going to explain how to install Oracle sample schemas, if they are not already installed. If you created a database sing DBCA , you can select to install the sample schemas: Please note that using this method (dbca) will install only the HR sample schema. Or you can install sample schemas … Continue reading Installing Oracle Sample Schemas (19.3)