PL/SQL program to print a string and number |PL/SQL|

-


PL/SQL

  • PL/SQL is a block structured language that can have multiple blocks in it
  • Pl/SQL stands for "Procedural Language extension of SQL" that is used in Oracle.
  • PL/SQL includes procedural language elements like conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types and triggers.


code:

DECLARE
name varchar(50):='Hello world';
reg_no varchar(20):='24';
BEGIN
dbms_output.put_line('Name: '||name);
dbms_output.put_line('Registered number: '||reg_no);
END;
/


Code Explanation:

  • dbms_output.put_line(): It is used for printing the output to the console screen.
  • The DBMS_OUTPUT is a built-in package that enables you to display output, debugging information.
  • The put_line is the most useful function to enable the package for the write data in the program. 
  • Here the first line turns on serveroutput. the SERVEROUTPUT setting controls whether SQL*Plus prints the output generated by the DBMS_OUTPUT package.
Declaration section contains a variable which is declared by the programmer. The variable is ‘message’ and the data type is varchar. 
  • The Execution section starts with the BEGIN keyword and we have given the variable declared in the Declaration section set as the parameter to the output statement.
  • Finally, we now write the END keyword to terminate the block of the Execution section.

Comments

Post a Comment

Popular posts from this blog

Use of Backslash "\n" in C language

-
 Why  Backslash "n" is used in "printf" in machine languages Answer: Backslash "\n" is used in many programming languages. It is called as newline character. We use Backslash "\n" to bring a newline in our output . This newline character is a type of escape sequence . This helps the programmer or the coder to display the output with an alignment . It also help others to see and understand  the output clearly. The Backslash "\n" is used only in "printf" statements There are also other escape sequence characters like "\t" . "\t" is use for tab space . It...
Read more

COHESION AND COUPLING material

-
  5.3 COHESION AND COUPLING   ●       We have so far discussed that effective problem decomposition is an important characteristic of a good design. ●       Good module decomposition is indicated through high cohesion of the individual modules and low coupling of the modules with each other. ●       Cohesion is a measure of the functional strength of a module, whereas the coupling between two modules is a measure of the degree of interaction (or interdependence) between the two modules. ●       Coupling: Intuitively, we can think of coupling as follows.   ●       Two modules are said to be highly coupled, if either of the following two situations arise: ●       If the function calls between two modules involve passing large chunks of shared data, the modules are tightly coupled ●     ...
Read more

Coding and Testing in software engineering

-
  ●       Coding is undertaken once the design phase is complete and the design documents have been successfully reviewed. ●       In the coding phase, every module specified in the design document is coded and unit tested. During unit testing, each module is tested in isolation from other modules. ●       After all the modules of a system have been coded and unit tested, the integration and system testing phase is undertaken. ●       Integration and testing of modules is carried out according to an integration plan. ●       The integration plan, according to which different modules are integrated together, usually envisages integration of modules through a number of steps. 10.1 CODING The input to the coding phase is the design document produced at the end of the design phase. The objective of the coding phase is to transform the desi...
Read more