Answer / shekharjchandra

Hope u mean the below question

can we write stored function in out parameters? how to call
through select statement? how to written more than one
value plz give the exmple?

As

can we write stored function in out parameters? how to call
through select statement? how to RETURN more than one
value plz give the exmple?

------
We can write stored function with both IN and OUT parameters.

We can call from select statement only if there is no OUT parameter in it, and that too the called function should not modify the table data what is referred in Select statement.
And other condition it should not return multiple values when it is referred in Select statement

In order to return more then one value you have to use OT parameters or return the value as record and loop through the returned values.

Regards
J

Explain the difference between drop and truncate commands in sql?

0 Answers  

---

what are null values? : Sql dba

0 Answers  

---

Explain the advantages and disadvantages of stored procedure?

0 Answers  

---

What is execute immediate?

0 Answers  

---

What are the popular database management systems in the it industry?

0 Answers  

---

What is sql architecture?

0 Answers  

---

i have a word ***********hello********world******. I require a o/p **********hello world**********, Need to delete the middle stars.

3 Answers  

---

what is the difference between granting and creating a view?

2 Answers  

---

write a procedure to print a statement or number not using "dbms_output.put_line" package.write a procedure instead of it using procdure name as "print" ex:- declare a number:=2; begin print(a); end; /* when U type above procedure 2 have to should be printed*/

2 Answers   iFlex,

---

how to dump a table to a file with 'mysqldump'? : Sql dba

0 Answers  

---

What is the best free sql database?

0 Answers  

---

what is called after appearing where clause

3 Answers  

---