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
Messages: 70
Registered: September 2007
Location: Rawalpindi
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.

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: 8737
Registered: November 2002
Location: California, USA
Senior Member
Previous Topic: converting a cursor into a table?
Next Topic: Using TABLE functions in select statement (merged 3)
Goto Forum:

Current Time: Wed Aug 23 10:53:17 CDT 2017

Total time taken to generate the page: 0.15351 seconds