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
- 6232 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
what does it mean to have quoted_identifier on? : Sql dba
What is trigger types of trigger?
What is compute?
Does sql view stored data?
what is a trigger in mysql? Define different types of trigger. : Sql dba
How do you explain an index?
How do you clear the screen in sql?
What is the advantage of index in sql?
Does inner join return duplicate rows?
What is sql and its types?
What is compilation error in pl sql?
How is indexing done in search engines?
What is synchronized subquery?
What is column?
How do I run a sql query in pgadmin 4?
