How to View Oracle Stored Procedure using SQLPlus?

by

check your casing, the name is typically stored in upper case

SELECT *
FROM all_source
WHERE name=”DAILY_UPDATE”
ORDER BY TYPE, LINE;

More Related Contents:

  1. Place to store PL/SQL block [closed]
  2. Determining location of relevant tnsnames.ora file
  3. ORA-12514 TNS:listener does not currently know of service requested in connect descriptor
  4. Oracle: Import CSV file
  5. Fetch Oracle table type from stored procedure using JDBC
  6. Passing an array of data as an input parameter to an Oracle procedure
  7. null vs empty string in Oracle [duplicate]
  8. Convert timestamp datatype into unix timestamp Oracle
  9. What is the difference between “AS” and “IS” in an Oracle stored procedure?
  10. When or Why to use a “SET DEFINE OFF” in Oracle Database
  11. Oracle stored procedure with parameters for IN clause
  12. PL/SQL ORA-01422: exact fetch returns more than requested number of rows
  13. Get resultset from oracle stored procedure
  14. How to kill a running SELECT statement
  15. check if “it’s a number” function in Oracle
  16. Sql*plus always returns exit code 0?
  17. SQL*Plus how to accept text variable from prompt?
  18. Trigger to enforce M-M relationship
  19. How do you get nicely formatted results from an Oracle procedure that returns a reference cursor?
  20. Convert epoch to date in sqlplus / Oracle
  21. Why are Oracle table/column/index names limited to 30 characters?
  22. Functions vs procedures in Oracle
  23. Is it possible to kill a single query in oracle without killing the session?
  24. oracle SQL plus how to end command in SQL file?
  25. How to see refcursor result/output in Oracle SQL Developer? [duplicate]
  26. oracle “table or view does not exist” from inside stored procedure
  27. Oracle SQL Developer: Show REFCURSOR Results in Grid?
  28. How to test an Oracle Stored Procedure with RefCursor return type?
  29. How can I issue a single command from the command line through sql plus?
  30. Difference between a user and a schema in Oracle?

Leave a Comment