Answer / 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

what is Complex index. how to create it?

2 Answers  

---

What are the modes of parameters that can be passed to a procedure ?

3 Answers  

---

Define union, minus, union all, intersect ?

0 Answers  

---

How do you bind variables in pl sql?

0 Answers  

---

Can we use two order by clause in query?

0 Answers  

---

What do you mean by field in sql?

0 Answers  

---

Give me some examples of predefined exceptions.

3 Answers  

---

what are the different functions in sorting an array? : Sql dba

0 Answers  

---

What is Referential Integrity?

3 Answers  

---

SQL Tuning, Oracle Server 10g: Why is the following hint invalid? SELECT /*+ first_rows parallel(table_name,paral_number)*/

1 Answers   Accenture,

---

How we can update the view?

0 Answers  

---

What is different between union and minus?

7 Answers   Accenture, TCS,

---