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

What language is oracle sql developer?

1066

---

What can sql server reporting services do?

1159

---

Explain isolation levels. : Transact sql

1102

---

Can we call a function containing dml statements in a select query?

1020

---

What are different sql data types?

1121

---

How do you copy a table in sql?

1105

---

how do you tune the slow running queries in oracle db , explain the methodology

3197

---

What is the current version of postgresql?

1124

---

What is sqlexception in java?

1031

---

Can we use insert statement in function?

1043

---

How to execute a stored procedure?

1148

---

Which sql most popular?

1025

---

What is sql not null constraint?

1086

---

How do you determine the current isolation level? : Transact sql

1199

---

How do you concatenate in sql?

1077

---