Running Anonymous Blocks of Code : Operators « PL SQL Operators « Oracle PL/SQL Tutorial






SQL>
SQL>  set serveroutput on
SQL>  declare
  2       v_length NUMBER :=5.5;
  3       v_width  NUMBER :=3.5;
  4       v_area   NUMBER;
  5   begin
  6       v_area:=v_length*v_width;
  7       DBMS_OUTPUT.put_line('Area:'||v_area);
  8   end;
  9  /
Area:19.25

PL/SQL procedure successfully completed.

SQL>








23.1.Operators
23.1.1.Operators
23.1.2.The basic arithmetic operators in action
23.1.3.Logical Operators in PL/SQL
23.1.4.Running Anonymous Blocks of Code
23.1.5.Arithmetic Operators
23.1.6.Exponentiation
23.1.7.The negation and identity operators in action.
23.1.8.Comparison Operators
23.1.9.The Relational Operators: =, <>, !=, ~=, <, >, <=, >=
23.1.10.Logical Operators
23.1.11.String Operators
23.1.12.Use of Comparison Operators with Strings