adspace


What is a function in oracle pl sql?

Answer Posted / Ranjit Pradhan

A function in PL/SQL is a named block that accepts input parameters, performs some computation, and returns a single value as output. Functions can be used to encapsulate logic, improve code readability, and reduce redundancy.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is primary key clustered index?

1028


Do we need to rebuild index after truncate?

1154


Is primary key always clustered index?

1101


Is inner join faster than left join?

1287


Can we use distinct and group by together?

1147


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2102


what is dbms? : Sql dba

1070


how to use regular expression in pattern match conditions? : Sql dba

1125


what are all the common sql function? : Sql dba

1141


what are aggregate and scalar functions? : Sql dba

1142


what is bcp? When does it used? : Sql dba

1065


what is collation? : Sql dba

1242


what are the advantages of sql ? : Sql dba

1154


What is your daily office routine?

2353


Does group by remove duplicates?

1120