Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between pass by value and eference by
value in oracle plsql
- 1 Answers
- 6305 Views
- I also Faced
- E-Mail Answers
Answer Posted / welcomeashwin
PASS-BY-VALUE(FUNCTION)
1)All parameters must be write-only using the IN mode
2)Parameters are locally scoped that cannot be changed
3)Any parameters can use any valid SQL or PL/SQL datatype.
Only functions with parameter lists that use SQL datatypes
work with SQL statements.
4)Any IN parameter can have a default value
5)The formal return values can use any SQL or PL/SQL
datatype, but pipelined return tables must use SQL.
6)Any system cursor is not writeable and must be passed as a
IN parameter
PASS-BY-REFERENCE (FUNCTION)
1)You must have one parameter as read-only or read-write
2)All formal parameters are locally scoped variables that
you can change during operation inside the function
3)Any parameters can use any valid SQL or PL/SQL datatype.
Only functions with parameter lists that use SQL datatypes
work with SQL statements.
4)Any IN parameter can have a default value
5)The formal return values can use any SQL or PL/SQL
datatype, but pipelined return tables must use SQL.
6)Any system cursor is not writeable and must be passed as a
IN parameter
PASS-BY-VALUE (PROCEDURE)
1)All parameters must be write-only using the IN mode
2)Parameters are locally scoped that cannot be changed
3)Any parameters can use any valid SQL or PL/SQL datatype.
4)Any IN parameter can have a default value
5)Any system cursor is not writeable and must be passed as a
IN parameter
PASS-BY-REFERENCE (PROCEDURE)
1)At least one parameter must be defined as read-only or
read-write.
2)Parameters are locally scoped that can be changed
3)Any parameters can use any valid SQL or PL/SQL datatype.
4)Any IN parameter can have a default value
5)Any system cursor is not writeable and must be passed as a
IN parameter
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
When do we use triggers?
What is procedure explain with program?
What is difference between pls_integer and integer?
What is the meaning of disabling a trigger?
Can we create a trigger on view?
Why do we use procedures?
What are the types of queries in sql?
What is the use of prepared statement?
Why we use stored procedure instead of query?
What is difference between inner join and self join?
What is the purpose of normalization?
What is error ora-01000: maximum open cursors exceeded
what is dbms? : Sql dba
What is pl/sql table? Why it is used?
What are types of indexes in sql?
