
September 30th, 2003, 01:53 PM
|
|
Registered User
|
|
Join Date: Sep 2003
Location: nm
Posts: 17
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
pl/sql format mask
I have declared the following variables:
variable name: city_population
value: 55000
data type: Number
variable name: statehood_population
value: 07/10/1890
data type: Date
I want to display city_population as 55,000 and statehood_population as July 10, 1890 using DBMS_OUTPUT. How do I use the format mask to do this? Should the format mask be used when declaring the variables or when displaying them? thanks!!
|