Home » SQL & PL/SQL » SQL & PL/SQL » query format .
query format . [message #230279] Wed, 11 April 2007 07:12 Go to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member

Hi,

I want the query output of Following.

output is :26,april 2006

thanks


Arun..
Re: query format . [message #230282 is a reply to message #230279] Wed, 11 April 2007 07:25 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Read about FORMAT MASKS.

MHE
Re: query format . [message #230296 is a reply to message #230279] Wed, 11 April 2007 08:21 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
akkumar81 wrote on Wed, 11 April 2007 14:12
Hi,

I want the query output of Following.

output is :26,april 2006

thanks


Arun..


select '        output is :26,april 2006' from dual;
Re: query format . [message #230313 is a reply to message #230296] Wed, 11 April 2007 09:14 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Laughing
Previous Topic: Error message ORA-01487
Next Topic: Insert with sum statement doesn't work
Goto Forum:
  


Current Time: Sun Dec 11 08:28:41 CST 2016

Total time taken to generate the page: 0.07564 seconds