A variable, by definition, is a name given to a memory space. In Oracle PLSQL a variable allows a programmer to store the needed data / values in variables while the program is being executed. The Syntax for declaring a variable in Oracle PLSQL is: variable_name [CONSTANT] data_type [NOT NULL] [:= DEFAULT initial value] For […]
plsql
Literals in Oracle PLSQL
Basically in Oracle SQL / PLSQL a literal is same as constant. Let’s see few types of literals. Text Literals Integer Literals 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 […]