Home / Interview / oracle :: General Questions

Interview :: oracle

41)

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:

Formal Parameters: Formal parameters are variables declared in a subprogram specification and referenced in the subprogram body.

Following procedure declares two formal parameters named empid and amt:

42)

What are the extensions used by Oracle reports?

 

 

 

 Oracle reports are use to make business enable with the facility to provide information   of all level within or outside in a secure way. Oracle report uses REP files and RDF        file extensions.

43) How to convert a string to a date in Oracle database?

Syntax: to_date (string , format)

Let us take an example :

It will return December 12, 2012.

44)

How do you find current date and time in Oracle?

The SYSDATE() function is used in Oracle to find the current date and time of operating system on which the database is running?

 

45)

What will be the syntax to find current date and time in format "YYYY-MM-DD?