Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> "NOT NULL value" for procedure arguments using user_arguments
Hello.
SQL> desc ccs.bongbong
PROCEDURE ccs.bongbong
Argument Name Type In/Out Default? ------------------------------ ----------------------- ------ -------- A VARCHAR2 IN DEFAULT B VARCHAR2 IN
Can anyone explain to me what query 'desc' becomes? I wish to find out how it determines the default flag for the procedure arguments. This information is not in user_arguments.
SQL> select argument_name, default_value from all_arguments 2 where object_name = 'BONGBONG';
ARGUMENT_NAME DEFAULT_VALUE ------------------------------ --------------------A
Thanks,
Morten Received on Mon Nov 18 2002 - 08:39:13 CST