How can I get only the First Name of all the Customers from the Table using a Single Query?

By: Jyoti Pandey | 12 May 2015 3:13 pm | 0 Comments

Hello Experts,

There are few records in a table.

One of the column is FIRSTNAME_MIDDLENAME_LASTNAME.

Means it contains FirstName MiddleName(Those who have) and LastName for all the records.

EX:- Samir_Kumar_Roy
Rakesh_Ranjan_Dash
Vishal_Sharma
Ragini_Jain
Raj_Shekhar_Reddy
and so on.

And my query is that how can I get only the FirstName of all the customers from the table using a single query?

Please assist here.

Thanks in advance.

Comments

No Comments Posted for this Article.

Query About Single Table-space.
Hello Experts A single tablespace supports maximum of 65,536 datafiles. If i created 10 tablespaces then 10X65,536. Is it right. Another thing is upt to how much size of datafile is...
Single Signon
What is the difference between authentication and Single Sign-On? In computer security, authentication is the process by which a computer, computer program, or another user attempts to confirm...
How to Search for +*-/ in String Using Oracle SQL Query
Hi All, i have a query select REGEXP_INSTR ('3.8+3.2', '[*+-/]') from dual; out put is 2. why because it is searching the dot(.) first but i want to it should return 3 because i...
Oracle/ SQL Wait Events Interview Questions and Answers
FAQ: Oracle/ SQL Wait Events1. What are wait events?Wait events are characteristic parts of the Oracle kernel source code that can contain Oracle sessions during execution. Oracle provides...

Get solutions from our experts!