compound DML trigger rA compound DML trigger created on a table or editioning view can fire at multiple timing points. Each timing point section has its own executable part and optional exception-handling part, but all of these parts can access a common...
What is PL/SQL? Procedural Language extension to SQL It integrates procedural constructs with SQL SET SERVEROUTPUT ON This command is used to send the output from the server to the screen Lesson 1-2 Introduction & Declaring PL/SQL Identifiers SQL> SET...
The Instr function is used to find the position of a string in another string. Optionally you can provide position m to start searching for the string and the occurrence n of the string. By default m and n are 1 which means to start the search at the...
What is Deadlock? A deadlock occurs when users try to place exclusive locks on each other’s objects. Ex:- User1 places an exclusive lock on Table1 and then tries to place an exclusive lock on Table2. User2 already has an exclusive lock on table2, and...
The following Query will display the members in a group EXEC xp_logininfo '
What is TUF File in log shipping ? TUF file stands for Transaction Undo File inWhat is TUF File in log shipping ? TUF file stands for Transaction Undo File in SQL Server, .TUF file is the Transaction Undo File, which is created when performing log shipping...
Which trigger will be fire on Table Stament levelor rowlevel we can't say which vl fire 1st...Optimizer will taken care of that...answer is confusing but u hav to tell spontaneously
A clustered index determines the order in which the rows of a table are stored on disk. If a table has a clustered index, then the rows of that table will be stored on disk in the same exact order as the clustered index. An example will help clarify what...
How Do Bulk Binds Improve Performance? The assigning of values to PL/SQL variables in SQL statements is called binding. PL/SQL binding operations fall into three categories: in-bind When a PL/SQL variable or host variable is stored in the database by...
Using Dynamic SQL with Bulk SQL Bulk binding lets Oracle bind a variable in a SQL statement to a collection of values. The collection type can be any PL/SQL collection type (index-by table, nested table, or varray). The collection elements must have a...
