About Oracle Pl Sql Declare Variable And Its Examples

Asked By Janet D Rivera 10 points N/A Posted on - 11/28/2016

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.

• Status:
• Question Views: 2256
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Others
• Question Tags: Oracle | SQL

Answered By Rozack Susan 0 points N/A #282405

About Oracle Pl Sql Declare Variable And Its Examples

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.

About Rozack Susan

Questions
3

Answers
3

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 11/28/2016
• Question Category: Others