How can I view the code of a stored procedure using sqlplus for Oracle 10g When I type in desc daily update it shows me the parameter but when I try to do the following select from all source where name daily update I get no rows selected What am I doing wrong

[oracle] How to View Oracle Stored Procedure using SQLPlus?

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

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

• concat yesterdays date with a specific time • ORA-28001: The password has expired • how to modify the size of a column • How to create a blank/empty column with SELECT query in oracle? • Find the number of employees in each department - SQL Oracle • Query to display all tablespaces in a database and datafiles • When or Why to use a "SET DEFINE OFF" in Oracle Database • How to insert date values into table • error: ORA-65096: invalid common user or role name in oracle • In Oracle SQL: How do you insert the current date + time into a table?

• How to create temp table using Create statement in SQL Server? • How do I pass a list as a parameter in a stored procedure? • SQL Server IF EXISTS THEN 1 ELSE 2 • Stored procedure with default parameters • Could not find server 'server name' in sys.servers. SQL Server 2014 • How to kill all active and inactive oracle sessions for user • EXEC sp_executesql with multiple parameters • MySQL stored procedure return value • SQL Server: use CASE with LIKE • SQL server stored procedure return a table

• Query to display all tablespaces in a database and datafiles • How to insert date values into table • Why do I get PLS-00302: component must be declared when it exists? • ORA-28000: the account is locked error getting frequently • Oracle Trigger ORA-04098: trigger is invalid and failed re-validation • Inserting Image Into BLOB Oracle 10g • Error System.Data.OracleClient requires Oracle client software version 8.1.7 or greater when installs setup • Different CURRENT_TIMESTAMP and SYSDATE in oracle • Search for a particular string in Oracle clob column • ORA-00984: column not allowed here

• When or Why to use a "SET DEFINE OFF" in Oracle Database • SQLPLUS error:ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA • sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory • How do I resolve this "ORA-01109: database not open" error? • How to echo text during SQL script execution in SQLPLUS • PL/SQL ORA-01422: exact fetch returns more than requested number of rows • how to pass variable from shell script to sqlplus • Connect to Oracle DB using sqlplus • sqlplus how to find details of the currently connected database session • How to output oracle sql result into a file in windows?