PLSQL TRIGGER.

“It is very important to the point of view.” Introduction: It is called as the stored procedures.It is run automatically by the database.The event occurs when there is the update in the table.It is basically the procedures.The modification statements such as the insert,update and delete. Syntax: create[ or replace] trigger  trigger_name before (or after) insert…

Read More

PLSQL PACKAGES.

Introduction: It is related to the code and the data .It includes the set of the procedures that will form an api .It includes the  type definitions and variable declarations.It is compiled and stored in the database.It’s content can be shared by the applications.It is the schema object that is grouped logically related to the…

Read More

PLSQL FUNCTION.

“We learn how to create and drop functions.We can declare,define and invoke it.It can be defined as the block with the name that is stored in the database.”   Introduction: We can create the function by using the parameters.It is similar to the procedure.It returns the value.But the procedure doesn’t return the value.The standalone function…

Read More

PLSQL PROCEDURE.

Introduction: It can be of the two types of plsql blocks i.e. named block and the anonymous block.It comes under the named blocks.It is the stored procedure.It accepts the zero or the more parameters such as in,out and in out.In indicates the input.Out indicates the output.In out indicates the input and the output.It does not…

Read More

Entry and Exist Criteria.

Introduction: It comes in the two phases of the testing i.e. static testing and the dynamic testing. There are four types of the criteria’s like: 1). Enter Criteria. 2).Suspension Criteria. 3). Resuspension Criteria. 4) Exist Criteria. Entry Criteria: It is the completely task independent. It is the set of the conditions. It depends on what…

Read More

PLSQL CURSORS.

“It will control the data processing.” Introduction: It is the set of the rows are together with the pointer. The pointer roles are to point the row. It is the database object used by the application in order to manipulate the data. It is used to manipulate the data in the row by row basis….

Read More

Database Trigger.

 ” The concept of this topic are similar in the case of Oracle,My SQL and SQL server.It can run when the specific actions occur on the table “ Introduction: It is the code that is automatically executed in response to the certain events on the particular table in the database. It is executed when we…

Read More

DIFFERENCE BETWEEN DROP,DELETE & TRUNCATE.

” The drop table will move the table to the recycle bin.If the cluster table are purged from the recycle bin,it can’t be recovered by using the purge command.For the creation of the new table,we have to specify the storage parameters. “         Save Save Save Save Save Save Save Save Save…

Read More

SQL CROSS JOIN.

  Introduction: In which each row of the one table are multiplied by the another row of the table. If the where clause have not been used, then it is called as the Cartesian join. If the where clause have been used, then it functions like the inner join. Syntax: Select table1.column1, table2.column2… from table1,table2;…

Read More

SQL JOIN TYPES.

“When we want to fetch the data from the two or the more tables based on the common field.”   Classification:  1). Inner Join. 2). Outer Join: It is divided into the three types. Left outer join/left join. Right outer join/right join. Full outer join. 3).Cross Join. 4). Self Join. Apart from these ,there are…

Read More