elsalmo 3alykom wa ra7mot allah wa barkato
argo elmosa3ada

I have XML File along these lines I need to parse this file from a location and want to keep the data in the Database .
My Question is how can I read this file using { PL/SQL or forms }and from a particular location.



xsi:noNamespaceSchemaLocation="azab"><Department><DEPTNO>1</DEPTNO><DEPTNAME>Modern Academy in Maadi</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>2</DEPTNO><DEPTNAME>Banha University</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>3</DEPTNO><DEPTNAME>Advanced Academy</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>4</DEPTNO><DEPTNAME>Modern Sciences and Arts University</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>7</DEPTNO><DEPTNAME>Sadat Academy For Management Sciences</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>10</DEPTNO><DEPTNAME>Arab Academy for Science and Technology</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>16</DEPTNO><DEPTNAME>Mansoura University</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>52</DEPTNO><DEPTNAME>Cairo University</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>53</DEPTNO><DEPTNAME>Ain Shames University</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>54</DEPTNO><DEPTNAME>Alsun Academy</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>55</DEPTNO><DEPTNAME>Alexandria University</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>56</DEPTNO><DEPTNAME>Helwan University</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>57</DEPTNO><DEPTNAME>Zagazig University</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>58</DEPTNO><DEPTNAME>Tanta University</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>59</DEPTNO><DEPTNAME>Higher Technological Institute</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>60</DEPTNO><DEPTNAME>Menoufia University</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>61</DEPTNO><DEPTNAME>El Alsun Higher Institute</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>70</DEPTNO><DEPTNAME>6th of October University</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>71</DEPTNO><DEPTNAME>El Hegaz Academy</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>90</DEPTNO><DEPTNAME>Benha Higher Institute of Technology</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>91</DEPTNO><DEPTNAME>Minia University</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>92</DEPTNO><DEPTNAME>Suez Canal University</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>110</DEPTNO><DEPTNAME>American University</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>111</DEPTNO><DEPTNAME>Azhar University</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>130</DEPTNO><DEPTNAME>Cairo Computer Academy</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>131</DEPTNO><DEPTNAME>6th Otober Institute for Business</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>132</DEPTNO><DEPTNAME>South Valley University </DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>150</DEPTNO><DEPTNAME>Misr University for Science and Technology</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>190</DEPTNO><DEPTNAME>Higher Institute for Languages</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>210</DEPTNO><DEPTNAME>Assiut University</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>211</DEPTNO><DEPTNAME>Workers University</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>230</DEPTNO><DEPTNAME>Higher Institute For Social Work</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>270</DEPTNO><DEPTNAME>Future Academy</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>290</DEPTNO><DEPTNAME>Social Service institution</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>310</DEPTNO><DEPTNAME>Social work Institution</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>330</DEPTNO><DEPTNAME>Technical Commercial Institute</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>350</DEPTNO><DEPTNAME>Delta Higher Institute for Computers</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>370</DEPTNO><DEPTNAME>High Institute For Agricultural</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>390</DEPTNO><DEPTNAME>High Egyptian Institute of Tourism and Hotels</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>430</DEPTNO><DEPTNAME>Women's College For Homeopathic</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>450</DEPTNO><DEPTNAME>None</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>451</DEPTNO><DEPTNAME>High Institute of Computer Science & Information System</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>471</DEPTNO><DEPTNAME>Coptic Garlis College</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>490</DEPTNO><DEPTNAME>High Institute of Administrative & Cooperative Studies</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>491</DEPTNO><DEPTNAME>Higher Institute for Cooperation Studies</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>530</DEPTNO><DEPTNAME>Higher Institute of Management</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>550</DEPTNO><DEPTNAME>El Madina Academy</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>570</DEPTNO><DEPTNAME>Art & Design Academy</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>610</DEPTNO><DEPTNAME>El Abasia For Computer Science</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>630</DEPTNO><DEPTNAME>Ramsis College Institute for Secretary</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>650</DEPTNO><DEPTNAME>Inistitute Quality Studies</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>670</DEPTNO><DEPTNAME>High Institute Of Applied Arts</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>690</DEPTNO><DEPTNAME>Higher Institute for Advanced Studies</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>710</DEPTNO><DEPTNAME>Aeronautical Science and Technology Institute</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>730</DEPTNO><DEPTNAME>Higher Institute for Specific Studies</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>731</DEPTNO><DEPTNAME>Misr International University</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>750</DEPTNO><DEPTNAME>6 October High Institute of Engineering</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>770</DEPTNO><DEPTNAME>Accor Academy</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>790</DEPTNO><DEPTNAME>Technical Institute of Alexandria</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>810</DEPTNO><DEPTNAME>High Institute for Management & Computer Science</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>811</DEPTNO><DEPTNAME>Madina Academy</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>830</DEPTNO><DEPTNAME>El Hegaz Institute</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>831</DEPTNO><DEPTNAME>El Alson High Institute</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>850</DEPTNO><DEPTNAME>Sorbone University ,Paris , France</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>870</DEPTNO><DEPTNAME>Tiba's Higher Inistitute</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>890</DEPTNO><DEPTNAME>El Gizera Institute</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>910</DEPTNO><DEPTNAME>High Instetuite of Business & Information System</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>930</DEPTNO><DEPTNAME>High Institute of Tourism & Specific Studies</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>931</DEPTNO><DEPTNAME>Sohag University</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>950</DEPTNO><DEPTNAME>High Institute for Development Studies</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>970</DEPTNO><DEPTNAME>Egyptian Socity of Cooperative Studies</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>990</DEPTNO><DEPTNAME>Thebes Academy</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>1010</DEPTNO><DEPTNAME>Alexandria Institute of Technology (ATI)</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>1030</DEPTNO><DEPTNAME>Academy for Tourism and Hotels</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>1050</DEPTNO><DEPTNAME>Higher Institute for Specialized Technological Studies</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>1051</DEPTNO><DEPTNAME>New Cairo Academy</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>1070</DEPTNO><DEPTNAME>Cairo Higher Institute for Computer Information & Management</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>1090</DEPTNO><DEPTNAME>Open University</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>1091</DEPTNO><DEPTNAME>Al Obour Academy for Technology</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>1092</DEPTNO><DEPTNAME>Mokatum Academy for Modern Science</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>1110</DEPTNO><DEPTNAME>Akhbar El Yom Acadamy</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>1130</DEPTNO><DEPTNAME>Higher Technical Institute</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>1150</DEPTNO><DEPTNAME>High Institute of Secretarial & Business Administration</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>1151</DEPTNO><DEPTNAME>Military Academy</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>1170</DEPTNO><DEPTNAME>Sbin El koom University</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>1190</DEPTNO><DEPTNAME>Higher Alsun Institute</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>1191</DEPTNO><DEPTNAME> Akhbar El Youm Academy</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department><Department><DEPTNO>1210</DEPTNO><DEPTNAME>Navel College</DEPTNAME><INSERT_DATE>11/22/2005 1:45:47 PM</INSERT_DATE></Department></Departments>

عليك بتعلم هذه دوال

موجوده على هذا الرابط يمكن تفيدك

http://www.araboug.org/ib/index.php?showtopic=11830