How to create oracle procedure??

From: Josef <std6673_at_et.fh-osnabrueck.de>
Date: Mon, 04 May 1998 14:27:42 +0200
Message-ID: <354DB43E.ADE5AD02@et.fh-osnabrueck.de>

Hi,

this is Josef. I am a student and have to develop an Oracle database!! I have developed a java applet which have to read out datas of an oracle database.
But it takes a lot of time to load the applet, because the database is very big and the applet read out a whole column of the database. Now I want to create a stored procedure, that my applet load first the procedure which is only returning or displaying what I need. I am using the SQL* Loader and my procedure have to read out the last column "datum".
Here is my SQL file to create the table. create table wetterdaten

       (uhrzeit number(9),
       temp2m number(10,2),
 luftt2m number(9,2),
 feuchttemp number(9,2),
 bodent1 number(9,2),

 bodent2 number(9,2),
 bodent3 number(9,2),

 einstrahl number(9,2),
 sonnendau number(9,2),
 windricht number(9,2),

 windweg number(9,2),
 niederschlag number(9,2),
 datum date );
exit

And no my question. How can I create a stored procedure? The procedure have to select
the last column(datum) of the table. I' m using Oracle 7.3!!

Thanks for your help in advance!!

Josef Teepe Received on Mon May 04 1998 - 07:27:42 CDT