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...
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...
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...
Dynamic Table Names and Moving Table
I'm fairly new to PL/SQL and I could use some help. I'm trying to create a cursor and build the tablename based on an input parameter. Currently I'm using DBMS.SQL statements, which I find cumbersome...

Get solutions from our experts!