Can you have two functions with the same name in a pl/sql
block?

Answers were Sorted based on User's Feedback



Can you have two functions with the same name in a pl/sql block?..

Answer / mahes

yes u can have two functions with same name and parameters
of differet data types .

these type of functions are called overloading function

Is This Answer Correct ?    28 Yes 1 No

Can you have two functions with the same name in a pl/sql block?..

Answer / saleem

Yes

Is This Answer Correct ?    9 Yes 1 No

Can you have two functions with the same name in a pl/sql block?..

Answer / srinivas.r

Yes.We can create the two functions with same name,but tyhe
parameter datatypes should be different.other wise it raise
an error.

Is This Answer Correct ?    3 Yes 0 No

Can you have two functions with the same name in a pl/sql block?..

Answer / pavan kumar

We can not create in plsql block or as a database object with same name but yes we can create in
package with same name and different parameters

Is This Answer Correct ?    0 Yes 0 No

Can you have two functions with the same name in a pl/sql block?..

Answer / muneer

WE CAN NOT CREATE IN PLSQL BLOCK BUT YES WE CAN CREATE IN
PACKAGE

Is This Answer Correct ?    2 Yes 3 No

Post New Answer

More Oracle Apps Technical Interview Questions

while doing the process of conversion if got any data error out what is the next step to reprocess

1 Answers  


where we will put the control file ,where we will run sql star loader what is the cmd?

1 Answers   Cap Gemini, KPMG,


What is sca and how is it useful?

0 Answers  


In what situation u create the BPA.

2 Answers   Accenture,


INBOUND INTERFACE: Suppose I have 100 Records of employees in flat file.When moving the records from flat file to STAGING table using .CTl file, I want to restrict the records whose salary is less than 500.what are the validations(or conditions) you write to achieve this.

2 Answers  


for report i have to parameters those are from_date and to_date ,so to_date should be greater when compare to from_date ,if we are giving to_date is less then it must shows some error how we willmake

3 Answers  


How can u populate data into po_headers_all segment2 column?

1 Answers   BirlaSoft,


why we can use synonym?

6 Answers  


which parameters passed in report in oracle developer how to pass

1 Answers   Wipro,


Presently u are working in which version?

4 Answers   Accenture,


List the types of flexfield?

0 Answers  


What is the package?

2 Answers  


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)