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.
Oracle Interview Questions
FILE param is used to specify the name of the export file to import. Multiple files can be listed, separated by commas.
Save points are used to divide a transaction into smaller parts. It allows rolling back of a transaction. Maximum five save points are allowed. It is used to save our data, whenever you encounter an error you can roll back from the point where you save your SAVEPOINT.
Save Points are used to divide a transaction into smaller phases. It enables rolling back part of a transaction. There are maximum 5 save points allowed in Oracle Database. Whenever an error is encountered, it is possible to rollback from the point where the SAVEPOINT has been saved.
Oracle version number refers: 9 – Major database release number 3 – Database maintenance release number 0 – Application server release number 5 – Component Specific release number 0 – Platform Specific release number
Translate is used to substitute a character by character while Replace is used to substitute a single character with a word.
Syntax: to_date (string , format) Let us take an example : to_date (‘2012-12-12’, ‘YYYY/MM/DD’) It will return December 12, 2012.
Logical backup is used to read a set of database records and writing them into a file. An Export utility is used to take the backup while an Import utility is used to recover from the backup.
The SYSDATE() function is used in Oracle to find the current date and time of operating system on which the database is running. SELECT TO_CHAR (SYSDATE, ‘MM-DD-YYYY HH24:MI:SS’) “Current_Date” FROM DUAL;
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 …