Building Expressions with Operators : Introduction « PL SQL Data Types « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. PL SQL Data Types
  3. Introduction

Expressions are constructed by using operands and operators.

An Example of a Simple PL/SQL Expression

SQL>
SQL> declare
  2      v_i1 NUMBER;
  3      v_i2 NUMBER;
  4  begin
  5      v_i1:=10/3;
  6      v_i2:=-v_i1;
  7  end;
  8  /

PL/SQL procedure successfully completed.

SQL>








21.1.Introduction
21.1.1.Block Structure
21.1.2.Your First PL/SQL Block
21.1.3.The slash character (/) at the end of the example executes the PL/SQL.
21.1.4.You can declare the whole string to be enclosed in quotes by using the construct q'!text!'
21.1.5.All identifiers within the same scope must be unique.
21.1.6.Building Expressions with Operators
21.1.7.PL/SQL datatypes
21.1.8.Variable Naming Rules
21.1.9.Introducing the Main Data type Groups