PLSQL PRACTICAL8

Local and Global Variables: The program below are about the global and the local variables.The local variables is declared under the nested block.The scope of the local and the global variables are similar to the programming languages.The printing statements are always coming in the begin part of the block statements. The global variables are accessible…

Read More

TestNG Introduction.

  About: It is used for the integration and  the unit testing.It is the annotation based testing.It is called as the superset of the Junit.It means that all the Junit characteristics and functions are included in it .The following annotations are having the close control i.e.@Configuration, @Data Provider,@ExceptedExceptions,@Factory and @Test. @Configuration: Under this,the following topics…

Read More

PLSQL BLOCK STRUCTURE.

  Introduction: It is called as the block structure language.Each block are performing the job/task of the single logic unit.It can be classified into the procedure ,function and anonymous blocks.It can have nested blocks.Each block are having three parts. Declaration part:It comes under the optional.It may or may not exist. Execution part:It contains the sub…

Read More

PLSQL OVERVIEW

  Introduction: It is the language launched by the oracle company for its products.It contains the procedural features of the languages like c plus and Sql.It is different from the other programming languages.It doesn’t have the conventional statements for taking the inputs and displaying the outputs. Read and write operations are not available in this…

Read More

PLSQL PRACTICAL6

  Division of the two numbers:   Explaination: In the above program, i have used the set serveroutput on for displaying the output.As we know that it supports the block of the statements.In the declare part,the datatype followed by the variable name are used like,datatype variablename;.In the begin part,the variable’s value are get assigned.For the…

Read More

PLSQL PRACTICAL 5

  Multiplication of two numbers:   Explaination:   In the above program,i have written the multiplication of the two numbers to obtain the final result.a and b are the two numbers respectively and c is the final result obtained after the multiplication.

Read More

PlSQL PRATICAL 3

“Please try to click on the picture,if it is not clear.”   Explanation:> We  can save any program written into the sql* plus into our computer system.By just copying and pasting the program into the sql* plus window.We can call the program from the command prompt.The file location where the file have been saved.In the…

Read More

PLSQL PRATICAL 2

“Please click on the picture,if it is not clear to you.”   Addition of two numbers: Here in the given picture,we are able to see the addition of the two numbers are 10 & 20 respectively to obtain the final results i.e. 30. Save Save

Read More

PLSQL Practical Classes 1.

” Please click on the picture to look better.Thank You.”           Explanation: In the above figure, i have tried to explain the basic   programs.First of all,just enter the username and password in the sql plus software.Username:scott & Password:tiger. Source Code: BEGIN DBMS_OUTPUT.PUT_LINE(‘Hello’); END; / Pl/sql procedure successfully completed. It contains…

Read More