Oracle Interview Questions | Eklavya Online

Oracle Interview Questions

What are actual and formal parameters?

Actual Parameters: Actual parameters are the variables or expressions referenced in the parameter list of a subprogram. Let’s see a procedure call which lists two actual parameters named empno and amt: raise_sal(empno, amt); Formal Parameters: Formal parameters are variables declared in a subprogram specification and referenced in the subprogram body. Following procedure declares two formal …

What are actual and formal parameters? Read More »

How to convert a date to char in Oracle? Give one example.

The to_char() function is used to convert date to character. You can also specify the format in which you want output. SELECT to_char ( to_date (’12-12-2012′, ‘DD-MM-YYYY’) , ‘YYYY-MM-DD’) FROM dual; Or, SELECT to_char ( to_date (’12-12-2012′, ‘DD-MM-YYYY’) , ‘DD-MM-YYYY’) FROM dual;