exam1

exam1 - conditions, self join n Aggregations, group by,...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
1 Exam1 n When: 3/3 4:30-5:45 n Where: classroom n What to bring: two page double sided cheat  sheet, pencils  n What NOT to use: any electronic devices  including desktop, laptop, cell phone, PDA
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
2 Exam1 n What to cover: SQL, PL/SQL part 1 n Materials: slides, in class discussions,  homework n What to expect:  n Write SQL n Write small PL/SQL program n True/False questions, need to give explanations
Background image of page 2
3 SQL n Joins: don’t  miss tables or join 
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: conditions, self join n Aggregations, group by, having 4 PL/SQL n Motivation for PL/SQL n Anonymous vs. named PL/SQL subprogram n Basic PL/SQL features: n Basic structure n Variables and Assignment n Control structures (if then, loop) n Using SQL in PL/SQL n Insert, update, delete n Implicit cursor (select) n Explicit cursor (select)...
View Full Document

Page1 / 4

exam1 - conditions, self join n Aggregations, group by,...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online