What is the difference between bind and declare variable in pl/sql?What is the difference between number,integer, pls_integer and binary integer?

Interview Candidate
Jun 27th, 2007
6
4818

Showing Answers 1 - 6 of 6 Answers

jamesravid
Profile Answers by jamesravid

Jul 18th, 2007

Bind variables are command line parameters.
whereas declare variables are variables local variables declared with in the pl/sql code.

scope of declare variables is within the procedure you can't use them outside of the pl/sql code. But bind variables are valid till the session is valid

rajakumar_na
Profile Answers by rajakumar_na

Nov 16th, 2007

One more point Bind variables are declared outside the pl/sql block whereas declare variables are declared with in the pl/sql block