• Skip to primary navigation
  • Skip to main content

Tech Honey

The #1 Website for Oracle PL/SQL, OA Framework and HTML

  • Home
  • HTML
    • Tags in HTML
    • HTML Attributes
  • OA Framework
    • Item in OAF
    • Regions in OAF
    • General OAF Topics
  • Oracle
    • statement
    • function
    • clause
    • plsql
    • sql
You are here: Home / Oracle / plsql / Literals in Oracle PLSQL

Literals in Oracle PLSQL

November 22, 2012 by techhoneyadmin

Basically in Oracle SQL / PLSQL a literal is same as constant.

Let’s see few types of literals.

  1. Text Literals
  2. Integer Literals
  3. Number Literals

Text Literals:-
Text literals in oracle plsql are always surrounded by single quotes (‘) e.g.
‘tech honey’
‘oracle’
‘plsql’
‘January 1, 2012’

Integer Literals:
Integer Literals in oracle plsql can be up to 38 digits long, they can be either positive or negative numbers. If no sign is specified then oracle plsql assume the literal to be positive. Some examples of Integer literals are:
20
+20
-20

Number Literals:
Number Literals in oracle plsql can be up to 38 digits long, they can be either positive or negative numbers. If no sign is specified then oracle plsql assume the literal to be positive. Some examples of Number literals are:
20
+20
-20
20e-4
20.0020


Filed Under: plsql Tagged With: how to use Literals in oracle database query, how to use Literals in oracle plsql, how to use Literals in oracle sql, Literals in oracle plsql, Literals in oracle sql, LITERALSPLSQL, syntax and example of Literals in oracle database query, syntax and example of Literals in oracle plsql, syntax and example of Literals in oracle sql, using Literals in oracle database query, using Literals in oracle plsql, using Literals in oracle sql

Copyright © 2023 · Parallax Pro on Genesis Framework · WordPress · Log in