Yurttas/PL/DBL/oracle/F/02/SPJ/index page

SPJ - [ plsql in sqlplus ]

---

• Document for plsql in sqlplus

• Suppliers-def.sp | Suppliers-des.sql
• Suppliers-ins.sp | Suppliers-q-all.sql
  
  
• Parts-def.sp | Parts-des.sql
• Parts-ins.sp | Parts-q-all.sql
  
  
• Projects-def.sp | Projects-des.sql
• Projects-ins.sp | Projects-q-all.sql
  
  
• Shipments-def.sp | Shipments-des.sql
• Shipments-ins.sp | Shipments-q-all.sql

• q01.sp
• q02.sp
• q03.sp
• q04.sp
• q05.sp
• q06.sp
• q07.sp
• q08.sp
• q09.sp
• q10.sp
  
  
• drop.osp
• get_avg.sql

• q-all.sql [query all system tables]
• c-all.sql [create all tables]
• i-all.sql [insert all tables]
• d-all.sql [drop all tables]