Oracle Questions asked in MNC

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 … Read more

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; In Oracle, you can use the TO_CHAR function to convert a date to … Read more

FILE param is used to specify the name of the export file to import. Multiple files can be listed, separated by commas. In Oracle’s IMP (Import) command, there is no direct parameter named “FILE.” However, there is a parameter named “FILE,” which is used in conjunction with the “FROMUSER” and “TOUSER” parameters to specify the … Read more

The SHOW option specifies when the value of show=y, the DDL within the export file is displayed. In Oracle, the SHOW option in the IMP (Import) command is not a valid or recognized option. The IMP command is typically used for importing data into an Oracle database, and it doesn’t have a SHOW option. If … Read more

The INDEXES option is used to determine whether indexes are imported. In Oracle, the INDEXES option in the IMP (Import) command is used to specify whether or not to import index definitions along with the data during the data import process. When you include the INDEXES option in the IMP command, Oracle will import both … Read more