About Oracle Pl Sql Declare Variable And Its Examples

Asked By 10 points N/A Posted on -
qa-featured

Hello , notify about oracle pl sql declare variable and also state the same with the example for the easy reference only. Reply asap and thanks.

oracle-pl-sql-declare-variable
SHARE
Answered By 0 points N/A #282405

About Oracle Pl Sql Declare Variable And Its Examples

qa-featured

Hello, the oracle pl sql declare variable, where the variable allows the program to store the data temporarily at the time of executing the code. Below shows its syntax:

variable_name [CONSTANT] data type [NOT NULL] [:= | DEFAULT initial value]
While declaring the variable the name should be as variable_name and the data type is valid in PL/SQL. Also it consists of semicolon to terminate the every statement as well. For example where salary is the data type and has length 6. And it declares two variable as well out of which one is not null.

declare-variable

Related Questions