var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
In Oracle Developer 2000 Report 6.0 , I would like to print '0000' against the NULL value of a column of a table, where column type is NUMBER with size 4 and for the values size less the 4 print them with a leading zero/s . See the Follwing exam :
How to implement this format ?
To convert NULL to zero use NVL(column,0).
To display in format 0000 set the field format mask to 0000.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors