Home » SQL & PL/SQL » SQL & PL/SQL » What is the difference
What is the difference [message #226730] Mon, 26 March 2007 06:08 Go to next message
Messages: 18
Registered: October 2006
Location: mumbai
Junior Member
In the below program what is the difference between


acct_balance NUMBER(11,2);
acct CONSTANT NUMBER(4) := 3;
debit_amt CONSTANT NUMBER(5,2) := 500.00;
Re: What is the difference [message #226733 is a reply to message #226730] Mon, 26 March 2007 06:13 Go to previous message
Michel Cadot
Messages: 63929
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"Database SQL Reference", Chapter 2 "Basic Elements of Oracle SQL", section "Datatypes", paragraph NUMBER Datatype.

"Database PL/SQL User's Guide and Reference", Chapter 1 "Overview of PL/SQL", section "Understanding the Main Features of PL/SQL", paragraph Understanding PL/SQL Variables and Constants.


[Updated on: Mon, 26 March 2007 06:16]

Report message to a moderator

Previous Topic: Logging stages of procedure
Next Topic: exception
Goto Forum:

Current Time: Wed Oct 26 11:08:42 CDT 2016

Total time taken to generate the page: 0.08363 seconds