can use the following like overloading concept in a single
package:

procedure p1(a varchar),
procedure p1(a varchar2),
procedure p1(a char)

Answer Posted / vpl

No.
for overloading, parameters must differ by type family--
whereas CHAR, VARCHAR and VARCHAR2 belongs to same family.

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which kind of parameters cannot have a default value in pl sql?

584


How do I make my sql query run faster?

454


Can procedure in package be overloaded?

597


What is ttitle and btitle?

567


what is 'mysqladmin' in mysql? : Sql dba

523






Can we use distinct and group by together?

576


What is a call statement? Explain with an example.

536


What are the basic sql commands?

538


How do I tune a sql query?

501


When is a declare statement required?

662


How do I write a cron which will run a sql query and mail the results to agroup?

515


what are all types of user defined functions? : Sql dba

534


what are the advantages a stored procedure? : Sql dba

534


What is dml statement?

507


how is myisam table stored? : Sql dba

595