Paul Izzo wrote:
Morning Paul,

LTRIM simply removes spaces from the left end of a string.
TRIM simply removes spaces from both ends of a string.
RTRIM simply removes spaces from the right end of a string.

I suspect what you need is SUBSTR as in :

email := SUBSTR(LTRIM(first_name),1,1) || trim(last_name);

Of course, you would check for NULLs etc before SUBSTR as in :

first_name := TRIM(first_name);
last_name := TRIM(last_name);

IF (first_name IS NULL) THEN
handle NULL first name here;
END IF;

IF (last_name IS NULL) THEN
handle NULL last name here;
END IF;

email := SUBSTR(first_name,1,1) || last_name;



Cheers,
Norm.

I would like to automatically write a users e-mail address based off
of the first letter of the user's first name combined with the user's
last name. Ex. Bob Smith = bsmith, Sally Jones = sjones etc...

I don't know which function to use RTRIM or TRIM to take just the first
letter of the user's first name.

Does anyone know how to go about this?

This looks remarkably like homework.

However I personally would use substr.

eg:

select substr(u.firstname,1,1) ||u. lastname
from users_tab u

I suggest you read the manual in particular the sections devoted to
Character Functions Returning Character Values.

http://download-west.oracle.com/docs...unctions2a.htm

On 14 Feb 2005 01:28:45 -0800, "Paul Izzo" <paul.izzo (AT) mosca-ag (DOT) com>
wrote:


Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.usenet.com

I assure you this is not homework. I simply posted an example that is
similiar to what I'm looking for in my database. I phrased my question
in a way that everyone would understand. That way I get the best
replies

Thanks Norman and "it's not me" for your help.

Paul Izzo wrote:

Speaking for myself ... I do not appreciate it when people play games,
and that is how I interpret it, to "get the best replies." If you have
a question ... post it along with the appropriate DDL and DML for us
to work with.

This looks like homework, smells like homework, and if it isn't your
use of TRIM in your example when anyone with 5 weeks of Oracle
experience would have known better ... screams student.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

Sorry that my question doesn't comply to you DA Morgen. I was just
looking for a way to create a trigger that would run one a tablespace.
But it's not possible. I don't remember the exact error message but it
had something to do with "mutilated tablespace".

Your replies don't really add any substance to the thread. Do us all
a favor when you think that this is "homework" or too simple for you.
It might not be so easy for someone else. If you don't have anything
constructive to say then keep it to yourself.

I assure you again that this wasn't homework.

P.S. I wasn't able to hand in my final project. I guess I'll drop out
of school and monitor forums as a so called Oracle know it all.

Paul Izzo wrote:

The error message was MUTATING not MUTILATED. And I'll stifle the
comment that is on the tip of my tongue.

Do yourself a favor ... provide enough useful and accurate information
for someone to help you if you wish such. But if it was not homework you
might want to seriously consider taking a basic Oracle class.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)