for function select package.funtname(parameter) from dual/table; for

How to get the procedure's, function's name from a package
if it is wrapped(both spec & body).

Question Posted / kart

Answer Posted / kart

for function

select package.funtname(parameter) from dual/table;

for procedure

exec packagename.procedurename(parameter);

u cant call the trigger

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

what is the difference between delete and truncate statement in sql? : Sql dba

1130

How to read xml file in oracle pl sql?

862

What is the maximum number of columns in sql table?

1089

How to display the records between two range in Oracle SQL Plus?

1101

Can we enter data in a table in design view?

913

What is cursor in pl sql?

1052

Does sql view stored data?

901

What is partition by in sql?

1002

Is there a 64 bit version of ssms?

897

Is a view faster than a stored procedure?

903

What is primary key and foreign key with example?

876

How many unique keys can a table have?

959

what is 'mysqlimport'? : Sql dba

977

How do you go back in sql?

942

what is meant by urlencode and urldocode? : Sql dba

1092