EMP and DEPT tables in Oracle

As an Oracle Developer, you might want to play along with tables that are analogous to real world. EMP and DEPT tables are the most often worked upon tables in Oracle. Mostly these tables are owned by user SCOTT. Along with EMP and DEPT, the other two commonly used tables are BONUS and SALGRADE.

Here I have given the table structures (DDL) and values (DML) of EMP, DEPT, BONUS and SALGRADE table.

Happy Programming!

Table Structures





Values in Tables

DEPT table values

EMP table values

SALGRADE table values

Note: Don’t forget to commit after inserting values.

Hope you like the article and feedback is highly appreciated.

You can also Subscribe here to stay updated on latest posts of OracleMine.com.

Leave a Reply

Your email address will not be published. Required fields are marked *