Home » SQL & PL/SQL » SQL & PL/SQL » Help with query (Oracle 10g,win2k)
Help with query [message #382978] Mon, 26 January 2009 22:23 Go to next message
sirfkashif
Messages: 70
Registered: September 2007
Location: Rawalpindi
Member
Dear all,
when i run the following query
select 'Hi,'||'Kashif'||'!'||' '||to_char(sysdate,'DayMonthDD') from dual 


the result of the above query is

Hi,Kashif!Tuesday January 27

and i want to remove spaces in between Tuesday and January and 27

i used trim function which did not produce the expected result as it removes only leading and trailing spaces.

any help will be appreciated.

Regards,
Kashif
Re: Help with query [message #382990 is a reply to message #382978] Mon, 26 January 2009 23:00 Go to previous message
Barbara Boehmer
Messages: 8625
Registered: November 2002
Location: California, USA
Senior Member
http://download.oracle.com/docs/cd/B28359_01/server.111/b28286/sql_elements004.htm#SQLRF00216
Previous Topic: converting a cursor into a table?
Next Topic: Using TABLE functions in select statement (merged 3)
Goto Forum:
  


Current Time: Sun Dec 04 04:19:34 CST 2016

Total time taken to generate the page: 0.07346 seconds