Reverse function

[deolalkar_pooja]

Hi to all,
table name: mail
email name
[email][e-mail][/email] abc
[email][e-mail][/email] def
[email][e-mail][/email] PQR
[email][e-mail][/email] XYZ

=======================================

QUERY:

List all email and names in lower letters without any blanks.

========================================

I ran ltrim(), rtrim() and lower() function on data successfully. But fail to retrieve this data. Will you please help me? I don't have any little bit idea about code.

[pratik_garg]

can you please explain - in which format you want this data??

if you want email concatenating with name, you can simply use "||" (without quotes)

like

select lower(trim(email)) || lower(trim(name)) from mail;

or if you want in separate columns then you need to replace "||" with "," only(again - without quotes ).

what you have done it is looking correct only.

:)

[debasisdas]

I really do not understand what do you mean by -- I ran ltrim(), rtrim() and lower() function on data successfully. But fail to retrieve this data.