OraFAQ Forum: SQL & PL/SQL » case if avec PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » case if avec PL/SQL

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

case if avec PL/SQL [message #676246]

Wed, 22 May 2019 17:20

sawssen
Messages: 1
Registered: May 2019

Junior Member

salut tt le monde ,
j'ai un algorithme je veux l'ecrire en pl/sql en pl/sql comment faire .help please:

case 1: date_debut_validite v 4 < date_debut_validite v 5
if date_fin_validite v 4 is null then
date_fin_validite v 4 := date_debut_validite v5-1

case 2: date_debut_validite v 3 = date_debut_validite v 4
if date_fin_validite v 3 is null then
date_fin_validite:=date_debut_validite v4-1

case 3: date_debut_validite v 2 < date_debut_validite v 3
if date_fin_validite version2 is null then
date_debut_validite v2 := date_debut_validite v3-1

case 4:date_debut_validite v1 <date_debut_validite v2
date_fin_validite v1 := date_debut_validite v2-1

Report message to a moderator

[Message index]

		case if avec PL/SQL By: sawssen on Wed, 22 May 2019 17:20
		Re: case if avec PL/SQL By: Michel Cadot on Thu, 23 May 2019 00:20

Previous Topic:	Help in building a Query
Next Topic:	How to get all child records from a table with multiple self referential integrity constraints? (merged 3)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 22:54:27 CDT 2024