Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle PL/SQL REAL Datatype      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

Term: REAL

Definition:
In Oracle PL/SQL, the REAL datatype is a floating-point ANSI SQL data type. Its Oracle equivalent is FLOAT, which has a precision of 63 binary digits. REAL can be used in both SQL and PL/SQL.

Example Syntax:

[VARIABLE] REAL


Example Usage:

In SQL, a table T_REAL is created which contains a column definition of type REAL. This demonstrates the SLQ support for REAL data type.

CREATE TABLE T_REAL
(ID NUMBER,
NUM REAL);

Table created.


The PL/SQL block below declares a REAL variable and assigns a value. This demonstrates PL/SQL support for REAL data type.

DECLARE 
L_NUM REAL;
BEGIN
L_NUM := 10;
END;

PL/SQL procedure successfully completed.



Related Links:
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 72 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?