chapter 9 - PROCEDURES Subprograms PROCEDURES FUNCTIONS o Subprograms SUBPROGRAM DECLARE(HEADER(SPECIFIC

chapter 9 - PROCEDURES Subprograms PROCEDURES FUNCTIONS o...

This preview shows page 1 - 4 out of 12 pages.

ﻊﺳﺎﺘﻟا ﻞﺼﻔﻟا تاءاﺮﺟﻹا RES PROCEDU ﺔﻴﺠﻣﺮﺒﻟا تاﺪﺣﻮﻟا Subprograms تاءاﺮﺟﻹا ﻞﺜﻣ ﻚﻟذ ﻞﺒﻗ ﺎهﺄﺸﻧإ ﻢﺗ ﻞآاروﻷا ﻞﺧاد ﺔﻇﻮﻔﺤﻣ ﺞﻣاﺮﺑ وأ تاﺪﺣو ﻞﻤﺸﺗ ﻰهو PROCEDURES لاوﺪﻟاو FUNCTIONS ﻮه ءاﺮﺟﻹاو ﻞﻤﻌﻟ تاءاﺮﺟﻹاو تﺎﻴﻠﻤﻌﻟا ﻦﻣ ﺔﻋﻮﻤﺠﻣ . ﺎﺴﺣ ﺔﻴﻠﻤﻋ وأ ﺔﻤﻴﻗ بﺎﺴﺤﻟ ﻰه ﺔﻟاﺪﻟاو ﺔﻴﺑ . ﻰﻟﺎﺘﻟا ﻞﻜﺸﻟا ﻰﻓ ﺎﻤآ ءاﺰﺟأ ةﺪﻋ ﻦﻣ نﻮﻜﺘﻳ كﻮﻠﺒﻟا نا ًﺎﻘﺒﺴﻣ ﺎﻨﻳأر ﺎﻤآ
Image of page 1
o تﺎﻧﻮﻜﻣ ـﻟا Subprograms : ﻰﻓ SUBPROGRAM ءﺰﺠﻟا لاﺪﺒﺘﺳﺈﺑ مﻮﻘ DECLARE ﻮه ﻪﻧﺎﻜﻣ ﺮﺧﺁ ءﺰﺠﺑ (HEADER) وأ (SPECIFICATION) ﻮﻠﺒﻟا ﺔﻴﻘﺑو ﺞﻣﺎﻧﺮﺒﻟا ﻒﻳﺮﻌﺗ وا سأﺮﻟا ﻰهو ك ﻰﻤﺴ BODY . ءﺰﺠﻟا ﻰﻓ ﻢﺘﻳ Header ﻰﺗﻷا : - ﺞﻣﺎﻧﺮﺒﻟا عﻮﻧ ﺪﻳﺪﺤﺗ Function مأ Procedure . - ﺞﻣﺎﻧﺮﺒﻟا ﻢﺳا . - تﻼﻣﺎﻌﻤﻟا (Parameters) ﺞﻣﺎﻧﺮﺒﻠﻟ ﻮﻟ تﺪﺟو . - عﻮﺟﺮﻟا ﺔﻤﻴﻗ RETURN) ( ﻟا ﻰﻓ ﻚﻟذو ـ (Function) ﻂﻘﻓ . - ﺔﻤﻠآ AS وا IS ﺔﻤﻠآو ﺞﻣﺎﻧﺮﺒﻟا ﻒﻳﺮﻌﺗ ﻦﻴﺑ ﻞﺼﻔﺗ ﻰهو ﺔﻴﺳﺎﺳا BEGIN ﺎﻣا BODY ﻦﻴﺑﺎﻣ ﻮه ىﺬﻴﻔﻨﺘﻟا ءﺰﺠﻟاﻮﻬﻓ BEGIN-END ﺎﻣا ﺎهﺬﻴﻔﻨﺗ داﺮﻤﻟا داﻮآﻷا ﻰﻠﻋ ىﻮﺘﺤﻳو ءﺎﻄﺧﻷا ﺔﺠﻟﺎﻌﻣو جارﺪﺘﺳا ﻪﻴﻓ ﻢﺘﻳو تاءﺎﻨﺜﺘﺳﻷا ءﺰﺟ . س : ءاﺮﺟﻹا ﻮه ﺎﻣ What Is PROCEDURE : ﻦﻣ عﻮﻧ ﻮه Subprograms تﺎﻧﺎﻴﺒﻟا ةﺪﻋﺎﻗ ﻰﻓ ﻪﻨﻳﺰﺨﺗ ﻦﻜﻤﻳو ﺔﻨﻴﻌﻣ ﺔﻴﻠﻤﻋ ﺬﻴﻔﻨﺘﺑ مﻮﻘﻳ ءﺰﺠآ ةﺪﻋﺎﻘﻟا ﻦﻣ Schema Objects رﺮﻜﺘﻤﻟا ﺬﻴﻔﻨﺘﻟا ﺪﻨﻋ ﻪﺋﺎﻋﺪﺘﺳا ﻢﺘﻳ ﻰﻜﻟ .
Image of page 2
ﺔﻣﺎﻌﻟا ﺔﻴﻐﻴﺼﻟا ﻞﻟ Procedure : ﺔﻤﻠآ مﺪﺨﺘﺴ OR REPLACE لاﺪﺒﺘﺳﻹ Procedure ﻢﻳﺪﻗ ﻢﺳﻻا ﺲﻔﻨﺑ ﻚﻟذ ﻞﺒﻗ ًادﻮﺟﻮﻣ نﺎآ اذإ . - دﻮآ PL/SQL ﺔﻤﻠآ ﻦﻣ أﺪﺒﻳ BEGIN ﻟا ﻞﺧاد تاﺮﻴﻐﺘﻣ ﻒﻳﺮﻌﺗ ﻢﺘﻳ و ـ Procedure ﻰﻓ ﻚﻟذو ﻦﻴﺑ ءﺰﺠﻟا IS|AS ﺔﻤﻠآو BEGIN ﺔﻤﻠآ ﻞﺒﻗ ءاﺮﺟﻹا ﻞﺧاد ﻂﻘﻓ ﺎﻬﻣاﺪﺨﺘﺳا ﻢﺘﻳو END ﺔﺻﺎﺨﻟا ﻟﺎﺑ ـ Procedure . - ﻠﻟ ﻦﻜﻤﻳ ـ Procedure ﻞﻣﺎﻌﻣ ﺬﺧأ ) Parameter ( وأ لا جرﺎﺧ ﻦﻣ ﻞﻣﺎﻌ Procedure عاﻮﻧأو ﻟا ـ Parameters ﺔﺛﻼﺛ ( IN OUT , OUT , IN ) - ﺔﻌﺳ وأ ﺔﺣﺎﺴﻣ ﺪﻳﺪﺤﺗ مﺪﻋ (Length) ﻟا ﻰﻓ تﺎﻧﺎﻴﺒﻟا عﻮﻧ ـ Parameter . عﻮﻧ ﻂﻘﻓ
Image of page 3
Image of page 4

You've reached the end of your free preview.

Want to read all 12 pages?

  • Fall '08
  • 5odfatrek

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes