Forum des TPs

TP 01 - Travail 2 « Applications Client /Serveur »

 
my picture
TP 01 - Travail 2 « Applications Client /Serveur »
by Mounir Medileh - Wednesday, 11 October 2017, 5:16 PM
 

Voici une requette SQL sur ORACLE pour creer un fichier XML


SELECT XMLElement("Emp", 
                   XMLElement("name", e.first_name ||' '|| e.last_name),
                   XMLElement("hiredate", e.hire_date)) AS "RESULT" 
FROM hr.employees e 
WHERE employee_id > 200 ;

RESULTAT de la requette :

-----------------------------------------------------------------------
<Emp><name>Michael Hartstein</name><hiredate>1996-02-17</hiredate></Emp>
<Emp><name>Pat Fay</name><hiredate>1997-08-17</hiredate></Emp>
<Emp><name>Susan Mavris</name><hiredate>1994-06-07</hiredate></Emp>
<Emp><name>Hermann Baer</name><hiredate>1994-06-07</hiredate></Emp>
<Emp><name>Shelley Higgins</name><hiredate>1994-06-07</hiredate></Emp>
<Emp><name>William Gietz</name><hiredate>1994-06-07</hiredate></Emp>
 
6 rows selected.



Picture of Mouadh BALI
Re: TP 01 - Travail 2 « Applications Client /Serveur »
by Mouadh BALI - Thursday, 12 October 2017, 12:09 AM
 
excellent! bonne idée.
Picture of Abd Samad Gori
Re: TP 01 - Travail 2 « Applications Client /Serveur »
by Abd Samad Gori - Tuesday, 31 October 2017, 9:17 PM
 

السلام عليكم 

هل تم رفع حجم رفع الملفات الى 10 ميقا