Can you have two functions with the same name in a pl/sql
block?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
Answer / muneer
WE CAN NOT CREATE IN PLSQL BLOCK BUT YES WE CAN CREATE IN
PACKAGE
Is This Answer Correct ? | 2 Yes | 3 No |
while doing the process of conversion if got any data error out what is the next step to reprocess
where we will put the control file ,where we will run sql star loader what is the cmd?
What is sca and how is it useful?
In what situation u create the BPA.
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.
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
How can u populate data into po_headers_all segment2 column?
why we can use synonym?
which parameters passed in report in oracle developer how to pass
Presently u are working in which version?
List the types of flexfield?
What is the package?