Startup and Shutdown modes in oracle database The parameter file contains the information of parameters which controls the database The default space or location where the parameter file resides is ORACLE_HOME/dbs The satrtup mount means creating (SGA)System...
Multiplexer Control Files Oracle (control-files) Multiplexer Oracle control files. How to add control files in Oracle. How to multiplex the control files with a spile. How to add a control file with a PFILE. It is strongly recommended to multiplex control...
#table refers to a local (visible to only the user who created it) temporary table. ##table refers to a global (visible to all users) temporary table. @variableName refers to a variable which can hold values depending on its type. Uses of Temporary Tables:...
Global Temporary Table: Global Temporary tables are visible to or available across all sessions. And all users. Global Temporary tables are created using the same syntax as a CREATE TABLE except the table name starts with "##" (two '#' signs). When the...
Temporary Table: Temporary tables are tables that are available only to the session that created them. These tables are automatically destroyed at the termination of the procedure or session that created them. Use of temporary tables in MS SQL Server...
Tech Mahindra PL/SQL Interview Questions Introduce yourself Tell me your project What are the packages, functions, procedures you developed in your project what are their Functionality? Difference between loop and bulk collect which is the faster way...
Polaris PL/SQL Interview Questions Tell me about yourself What is your front end How to pass data to java Diff b/w procedure and function Can we use all kind of function in function What is trigger and trigger types Do you know about analytical queries...
Optimizer hints can be used with SQL statements to alter execution plans Hints let you make decisions usually made by the optimizer. As an application designer, you might know information about your data that the optimizer does not know. Hints provide...
The INLINE pragma specify that a sub program call is, or is not, to be inlined. Inlining replaces a sub program call (to a sub program in the same program unit) with a copy of the called sub program. To reiterate, with sub program inlining, Oracle will...
Pragma compiler directives instructs compiler with certain information. It is Processed at compile time not at run time. The directive restricts member sub programs to query or modify database tables and packaged variables. PRAGMA directive should be...
