Home » SQL & PL/SQL » SQL & PL/SQL » format mask
format mask [message #1116] Tue, 02 April 2002 17:44 Go to next message
fidelia
Messages: 3
Registered: April 2002
Junior Member
I'd like to know what is format mask and when/how to use it.
thanx a lot
Re: format mask [message #1121 is a reply to message #1116] Tue, 02 April 2002 21:21 Go to previous messageGo to next message
Epe
Messages: 99
Registered: March 2002
Member
Hello,

a format mask is nothing more than a certain format you give to an output. For example : a date in your database is kept in a date variable in the next form :
15-jan-02. In case you want to put it in another form (let's say like 15-01-2002), then you have to give the date a new format : to_char(date,'DD-MM-YYYY'). This is a format mask : you give the date a new face, a new mask but only on format level, the contents or meaning remains the same.

Success,

epe
Re: format mask [message #1602 is a reply to message #1121] Wed, 15 May 2002 10:33 Go to previous message
Nadeem Zia
Messages: 1
Registered: May 2002
Junior Member
I have a problem with FM. When I was using it on sql/plus , it didnt give me the result.

I need to display telephone number whihc I mentioned in variable like 9372366666, & I need to display it like: (937) 236-6666.
With the help of FM"("999")" 999"-"9999.

Please help me out.

Thanx
Previous Topic: Re: Sequence reseted automatically ?
Next Topic: Why use OUT parameters??
Goto Forum:
  


Current Time: Thu Mar 28 14:33:26 CDT 2024