To get a result similar to sp_helptext SQL Server procedure in Oracle, you can use the following query:
SET LINESIZE 132
SET LONG 4000
SELECT TEXT
FROM ALL_SOURCE
WHERE NAME = 'YOUR_PROCEDURE_NAME'
If you have another solution, please let me know… I didn’t find anything better than this…
No comments:
Post a Comment