PL/SQL Complete Tutorial. All Topics Covered

You can read PL/SQL completely here . This file covers all PL/SQL topics. Read and rate my work! Thanks
01) PL/SQL Overview
02) Data Types
03) Variables
04) Constants
05) Operators
06) Procedures
07) Functions
08) Cursors
09) Records
10) Exceptions
11) Triggers
12) Packages
12) Transactions
13) Conditions
14) Loops

Read and rate my work. Thanks

1. Made by: Dania Maitre
Dee Mn et Pevterar
¡Eva DC

2. OP CORA GE TER

AYuldtiea

ABRE QUIaiTES

3. IE]

4. Melba LE

== |

5. Delimiter Description

7. AU teva DEN Ain

COI

CO

CO

8. ns

9. Field Name Valid Datetime Values

10. DataType Description

Size

11. LE Na

12. à ántego
€ intege
E real

dbms_ output put_live|

das. output put_Line

Value of f

PL/SQL procedure successfully completed.

Global variables
das. output put_Live
das. output put Line

Local variables
dbas_output put_Line
ba output put ine

Outer Variable numa:
Suter Variable m2

PL/SQL procedure successfully completed

13. Table Created

€-43 custoners.saxtype

&-addr custoners.address:type:

a customers aalarystype

SELECT name, address, salary INTO came, c_addr, c_sal

dbns_output put_ Line,

en;

PL/SQL procedure completed successfully

14. MONA AN EA

15. Reine eae]

dbms_output.put_Léne

16. MLA QSAR

A

17. AA]

18. Exam

perator Operat

19. Mia NPIONE]

I condition

y

21. USAS EEES

23. MUO RUEDAS ENE

when 1

24. PL/SQL procedure successfully comple

25. EE

26. bas output-put Line( ‘a is Less than 20

a is loss than 20
alve of als: 10

sl “customers. salarystype

SET salary = salary + 1000
bas output put Line (‘Salary updated

27. uu
2
N
pail
del
da
Nr
EN
(a
Nc"

iteo

28. gon output put_Line

Value of a 43° 4

29. ANS

30. EHOW WEINER EY TLS ENEE

31. MERINO]

Condona Code

33. AL PAS Lege ENE

PL/SQL procedure successfully completed

dhms output.put Lin After Bt x is: © || x);

35. Mee ia RO ors ENE

36. pleted.

37. MLSs ME TENEN

38. QUAN eb OS]

oor

40. LOGIC CEUTONES |

41. ‘dbms_output .put_Line

«dure successfully

43. dbms output. put_Line(” Minimum of

dbms output put_Line(’ square of (2

45. DFE GUEUN ETON

46. © 1= totalcustomers()
dbas.output put Line( Total ro. of Customers: * |] €)

PL/SQL procedure successfully completes

FUNCTION FirdMax(x IN number, y IN number)

indnax(a, b)
dbas_ output.put_Line(" Maximum of (23,45): ' ||);

47. ure successfully comple

dbms_ output put_Lane(” Fa

dure successfully completes

48. Museo hia CUO

49. total_rows number (2
TF sqlsnotfound THEN
dbns output put-Line( ro customers sole

PL/SQL procedure successfully completed

51. LUPGIEMECCRUE |

52. «dure successfully completed

field net datatypet (NOT NULL) [= DEFAULT EXPRESSION)
fieldmmez datatype2 [WoT MULL) (= DEFAULT EXPRESSION)

Field ramen datatype [MOT NULL] [:= DEFAULT EXPRESSION)

(tite varchar(50)

53. - Book 1 specification
book subject

book title ie
book? subject
book book 13

dbms output Put Line books. title
dbms_ output put Line ook subject
dbms_ output put Line book ook 44

dbns output pur Lire book. tite:
dns output Put Line ook author
das output put Line ook subject
dbms- output put Lire Book book Ad

Book 1 title : € Programming
Book à author + Muna Ala

Book 1 Subject : € Programming Tutorial
Book 2 title : Telecom Billing

Book 2 subject : Telecom Billing Tutorial
Book 2 book 4d

PL/SQL procedure successfully completed.

‘ype books is record
title” varchar
‘subject varchar

dbas_ output put_Line book, title)
ddons-output.put_Line book author
Sons output put Lire Book subject!
dloms_output.put_Line book: book ia

- Book 1 specification
books title

54. ‘anning Tutorial

Telecom Billing
Zara Als

Lu completed.

55. Mbit Aes ens

56. Sivanis à

dons output put. Lane

57. Exception Oracle SQLCODE Description
Error

59. Uleila

60. al ditt number

ddbms output put _Line('Old salary: ' || :OLD.salary);
dons output put-Line( New salary: * || :NEW salary)
das output put line( ‘Salary differeme: "11 sal daft

62. CIRO ioieo

63. [U

value for cc id: 2

PL/SQL procedure successfully completed.

PROCEDURE addCustomer(c_id customers. idxtype,
Tune customers nanextype,
‘addr Customer s.addressstype,
Sal! customers. salarystype!

PROCEDURE UelCustomer(c_4d customers AuxTVPE)
LL customers

64. Enge customers agestype
&-adûr “customers addressitype
P'NALUES(E AB, name, cage, aid, es);

PROCEDURE delcustoner(c_4d custoners.ddstype) 15

PROCEDURE listcustomer 1S,
TYRE ¢-List 15 TABLE OF customers. nanentype:
Counter integer =;
dbms-output put Line( ‘customer’ |jcounter |] +): {rame 11st{counter)
Eno Listcustomer

code customers. sdhtype:= 9

"e package addcustoner(7, ‘Rajnish', 25, ‘chennai’, 2500)
package adicustomerí(8, 'Subhan, 32, "Delta", 7500)
E rackage.Astcustomer

66. LOS CUS ANA CAIN