session6

session6 - I2IT Assignments Create a procedure that returns...

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

View Full Document Right Arrow Icon
Oracle App. I2IT
Background image of page 1

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

View Full DocumentRight Arrow Icon
Oracle App. I2IT
Background image of page 2
Oracle App. I2IT
Background image of page 3

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

View Full DocumentRight Arrow Icon
Oracle App. I2IT
Background image of page 4
Oracle App. I2IT
Background image of page 5

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

View Full DocumentRight Arrow Icon
Oracle App. I2IT
Background image of page 6
Oracle App. I2IT
Background image of page 7

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

View Full DocumentRight Arrow Icon
Oracle App. I2IT
Background image of page 8
Oracle App. I2IT
Background image of page 9

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

View Full DocumentRight Arrow Icon
Oracle App. I2IT
Background image of page 10
Oracle App. I2IT
Background image of page 11

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

View Full DocumentRight Arrow Icon
Oracle App. I2IT
Background image of page 12
Oracle App. I2IT
Background image of page 13

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

View Full DocumentRight Arrow Icon
Oracle App. I2IT
Background image of page 14
Oracle App. I2IT Examples Inout ProcedureWithCursor
Background image of page 15

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

View Full DocumentRight Arrow Icon
Oracle App. I2IT
Background image of page 16
Oracle App. I2IT
Background image of page 17

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

View Full DocumentRight Arrow Icon
Oracle App. I2IT
Background image of page 18
Oracle App. I2IT
Background image of page 19

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

View Full DocumentRight Arrow Icon
Oracle App. I2IT
Background image of page 20
Oracle App. I2IT
Background image of page 21

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

View Full DocumentRight Arrow Icon
Oracle App. I2IT
Background image of page 22
Oracle App. I2IT
Background image of page 23

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

View Full DocumentRight Arrow Icon
Oracle App. I2IT
Background image of page 24
Oracle App. I2IT Examples passing parameters PositionalParam NamedParam UseOfDefault
Background image of page 25

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

View Full DocumentRight Arrow Icon
Oracle App. I2IT
Background image of page 26
Oracle App. I2IT
Background image of page 27

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

View Full DocumentRight Arrow Icon
Oracle App. I2IT
Background image of page 28
Oracle App. I2IT
Background image of page 29

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

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

Unformatted text preview: I2IT Assignments Create a procedure that returns the highest paid employee in a particular department. Specifically, this procedure takes a deptno as input and returns empno, ename, and sal in the form of three out parameters.(use named parameter) Write a procedure p1 which accepts deptno as input parameter, returns employees names having same deptno. Oracle App. I2IT Assignment Create a procedure INCR which takes the employee number and increases the salary of an employee. The employee numbers and the amount to be incremented is passed as parameter.Handle all exceptions.(use positional parameters) Oracle App. I2IT Assignment Create a procedure with records which shows the output of the following query select avg(sal) asal,min(sal) msal, dname,dept.deptno from dept,emp where emp.deptno=dept.deptno group by dname,dept.deptno;...
View Full Document

This note was uploaded on 07/15/2011 for the course ECO 2023 taught by Professor Mr.raza during the Summer '10 term at FAU.

Page1 / 37

session6 - I2IT Assignments Create a procedure that returns...

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

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