PL/SQL Input Output Statements


Prev Tutorial Next Tutorial

PL/SQL Input Output Statements

Input Statement

There is no input statement or input function to print the values at run time but if you want to input the value at run time then you use insertion operator (&).

Output Statement

Output statements are used for print output on console, pl/sql have own output statements to print value on screen which is;

Syntax

dbms_output.put_line();

Example

dbms_output.put_line('Hello word');

Syntax

dbms_output.put_line('Message' || variable);

Example

dbms_output.put_line('Sum: ' || c);

Prev Tutorial Next Tutorial

Advertisements




Facebook Likes

Advertisements