Answer / anoop

Yes we can use out parameter in functions, it is of great
use when we intend to return more than one value from a
function.

Answer / reddyreddy143

1.Yes we can use out parameters in a function.but we have
to assign the out parameter value to the return datatype.
2.But when we use out parameters in function we can't call
the function from a select statement

Answer / abhishek

Yes we can use the out parameter in function. But it does
not as any use as the value will be return to the calling
statement by the keyword return.

Answer / suresh babu

Yep,we can use the out parameter in Function,the Function won't show the error when using the out parameter.But it is meaningless.The Function,which used the out parameter never return the result.The IN parameter only useful for Functions.

What will be the output of the following String S = 1+2+"abc" S = ? String S1 = 1+2+"abc"+5+6 S1 = ?

1 Answers   ABC,

---

How many database objects (trigger, packages, sequence etc) uses a particular field in a given table. For ex: I want to know how many database object uses the ATTRIBUTE1 in the PO_VENDORS table. What query will give me the result showing the database object name(package, trigger etc), field_name used (in this case ATTRIBUTE1) and table_name (in this case PO_VENDORS).

2 Answers   IBM,

---

What are sql*plus environment variables?

0 Answers  

---

what is union, minus and interact commands? : Sql dba

0 Answers  

---

What is Highwatermark?

3 Answers   Thermotech,

---

explain commit and rollback in mysql : sql dba

0 Answers  

---

What are different functions in sql?

0 Answers  

---

Hi All, I am new to both this blog and technology. I was able to see a response for one of the questions on triggers as below. I would like to know why are we using " if rtrim(to_char(sysdate,'day'))=rtrim('sunday') then" instead, can't we use " if sysdate = 'sunday' then". I can understand the use of "rtrim", but dont know y v r using to_char. I have seen this in many cases but did not get a convincible explaination. Please help me with this and do excuse if this question sounds silly. Thanks in advance...... create or replace trigger trg_sun before insert on <table name> begin if rtrim(to_char(sysdate,'day'))=rtrim('sunday') then raise_application_error(-20345,'no transaction in sunday'); end if; end trg_sun;

2 Answers  

---

What are the types of SQL Statement?

3 Answers  

---

What are the ddl commands?

0 Answers  

---

What is a system versioned table?

0 Answers  

---

Why we use triggers in mysql?

0 Answers  

---