|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
May 12th, 2005, 07:28 AM
|
|||
|
|||
|
stored procedure question
hi, i have created a stored procedure for an assignment i have, the procedure is called getschoolorder, this procedure worked i implemented it into thte database then somehow i didnt save a copy of it and i lost hte code for the procedure, i have to hand hte code in, is there anyway i can get the code with an sql querie or somethign im using oracle 9i,
i basically asking ofr the sql to get the procedure code to the screen
|
|
#2
May 12th, 2005, 07:56 AM
|
||||
|
||||
|
Code:
select
DBMS_METADATA.GET_DDL('PROCEDURE',u.object_name)
from
user_objects u
where
object_type = 'PROCEDURE';
read more here
__________________
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)
|
|
#3
May 12th, 2005, 08:27 AM
|
|||
|
|||
|
thanx for the reply
that code only shows me all my procedures, i actually need the code that made up the procedure on the screen as i have to hand that code in to be assessed so what do i do to show my procedures code
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > stored procedure question |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
