Home » SQL & PL/SQL » SQL & PL/SQL » case if avec PL/SQL
case if avec PL/SQL [message #676246] Wed, 22 May 2019 17:20 Go to next message
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
Re: case if avec PL/SQL [message #676250 is a reply to message #676246] Thu, 23 May 2019 00:20 Go to previous message
Michel Cadot
Messages: 68042
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Welcome to the forum.
Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Also always post your Oracle version, with 4 decimals, as solution depends on it.

PL/SQL User's Guide and Reference

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:

Current Time: Sun Nov 28 02:56:38 CST 2021