|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
May 15th, 2005, 04:33 AM
|
|||
|
|||
|
Simple Stored Procedure
I'm using Oracle 9i for the very first time and I'm trying to create a stored procedure that basically displays all the data from one table using output.put_line command. Can anyone guide me on this?
create or replace procedure display_artist_table is begin dbms_output.put_line('help me please'); end; the sql statement is basically SELECT * FROM artist;
|
|
#2
May 16th, 2005, 09:41 AM
|
||||
|
||||
|
Create a cursor as select * from table, then loop through it outputting the results.
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias)
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > Simple Stored Procedure |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
