Operators in PL/SQL

The operators which we are using in SQL the same Operators  supported by PL/SQL.

Input Statement in PL/SQL-
 There is no input statement or input function to input the values at run time. If you want to use i/p the value at run time we need to use insertion operation in PL/SQL.

Output Statement in PL/SQL-
dbms_output.put_line() - this is output statement that are using in PL/SQL programing language.

There are following type of output statement using in PL/SQL statement.

Syntax 1- dbms_output.put_line("message");
exp.-        dbms_output.put_line("infoindiatech");

Syntax 2-  dbms_output.put_line('message' || variable);
exp.-         dbms_output.put_line('sum of two number is' || c);

Syntax3-   dbms_output.put_line(variable);
 exp.-        dbms_output.put_line(c);

what is Block in PL/SQL-
Block is grouped code or set of statement these block are classified into two parts
1-Anonymous Block or Unnamed Block-Anonymous block are those block which we can not store permanently in the database.
Once the user log off from the database the block are completely vanished these block also called Unnamed block.
2-Subprograms- Subprograms are those block which we can store permanently in the database so that user at any particular point of time can access these block.
These block referred with some name so these block can be called named PL/SQL Blocks.