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.

Hi I am Paras.

Thanks for stopping by at OracleMine.com. Speaking about my brief introduction, I work for a multinational organisation in Oracle related technologies. Being an avid blogger, I would like to inform you about my productivity and motivational blog XpressPlanet.com. Speaking of OracleMine.com, I will try my best to share knowledge on technologies in as simple and understandable manner as possible. You can also contribute your knowledge on OracleMine by writing to us at hioraclemine@gmail.com. Again I appreciate your visit. Hope to see you again and again!

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.