Member Avatar for nychick

Not sure if this is the right forum for SQL statement problems.

I've searched all over but don't know how to output formatted SQL queries. Like Selecting the first letter of the first name and then last name with proper spacing.

  • 3 Contributors
  • 3 Replies
  • 163 Views
  • 5 Months Discussion Span
  • Latest Post Latest Post by pratik_garg
Member Avatar for debasisdas

what exactly you are looking for ?

Member Avatar for nychick

what exactly you are looking for ?

I'd like to extract the first letter of the first name then period then last name.

So John Smith is

J. Smith

Member Avatar for pratik_garg

it is very simple nychick

okay lets take an ordinary table structre having information about first name and last name of some persome

table_name = person

------------------
first_name
last_name
.....
....
.... (so on some more table columns)
-------------------


so for what you want you have to write following query in oracle

select substr(first_name,1,1) || '  ' || last_name from person;

please let me know if i have misunderstood your question or if you need any clarification....

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.