exam2

exam2 - Exam2 n n n n When:4/144:305:45 Where:classroom

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

View Full Document Right Arrow Icon
Exam2 n When: 4/14 4:30-5:45 n Where: classroom n What to bring: two page double sided cheat  sheet, pencils  n What NOT to bring: any electronic devices  including 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
Exam2 n authorization, XML n Materials: slides, exercises, homework n What to expect:  n Write PL/SQL procedure and functions n Write a trigger n Given grant/revoke statements, decide who has the  privilege n Short answer questions (decide whether a statement is  correct and explain)
Background image of page 2
n Procedures n Can receive and pass multiple parameter  values n Can call other program units n Functions n Like procedures, except they return a  single value
Background image of page 3

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

View Full DocumentRight Arrow Icon
Creating a Procedure CREATE OR REPLACE PROCEDURE procedure_name ( parameter1 mode datatype, parameter2 mode datatype , … ) IS | AS local variable declarations BEGIN program statements EXCEPTION exception handlers END; header body Differences with anonymous subprograms?
Background image of page 4
Using Procedure n Use parameter in cursor n How to call a procedure with output  parameter?
Background image of page 5

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

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/28/2012 for the course IS 620 taught by Professor Chen,z during the Spring '08 term at UMBC.

Page1 / 16

exam2 - Exam2 n n n n When:4/144:305:45 Where:classroom

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

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