session3 (2)

session3 (2) - Oracle App. I2IT Oracle App. I2IT Oracle...

Info iconThis preview shows pages 1–36. 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
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 Example loop ctr:=ctr+1; If ctr=10 then Exit; End if; End loop LOOP Ctr:=ctr+1; EXIT WHEN ctr=10; END LOOP
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 examples Write a PL/SQL code to update salary of employee number –7788 to 3000 if salary is less than 3000
Background image of page 24
Oracle App. I2IT Solution declare x emp.sal%type; begin select sal into x from emp where empno=7788; if x<3000 then update emp set sal=3000 where empno=7788; end if; end; /
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 PL/SQL records must be declared in two steps. First you declare a RECORD type, then declare records of that type.
Background image of page 30
This is the end of the preview. Sign up to access the rest of the 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 / 42

session3 (2) - Oracle App. I2IT Oracle App. I2IT Oracle...

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

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