PL/SQL Input Output Statements
Advertisements
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);
Google Advertisment