Prepare for your Next Interview

• GeekInterview
• Knowledge base
• Interview Questions
• Tech FAQs

How can I get records in follwing format?

This is a discussion on How can I get records in follwing format? within the SQL forums, part of the Databases category; suppose in table named customer has a column named ename having values like james,john ,suji_paric,scott_tiger. i want retrieve the column value like james john suji scott...

Geeks Talk > Databases > SQL How can I get records in follwing format?

User Name Remember Me? Password

Register

FAQ

Members List

Calendar

Mark Forums Read

Thread Tools

Display Modes

#1 (permalink)   05-17-2008

aurobinda.dalai Junior Member   Join Date: Mar 2008 Posts: 2 Thanks: 0 Thanked 0 Times in 0 Posts

How can I get records in follwing format? suppose in table named customer has a column named ename having values like james,john ,suji_paric,scott_tiger. i want retrieve the column value like james john suji scott

Sponsored Links

#2 (permalink)   05-17-2008

krishnaindia2007 Expert Member   Join Date: Sep 2007 Posts: 614 Thanks: 22 Thanked 52 Times in 51 Posts

Re: How can I get records in follwing format? Use the following statement SQL> select substr(name,1,decode(instr(name,'_'),0,length(name),instr(name,'_')-1)) from test_data; SUBSTR(NAME,1,DECODE -------------------- james john suji scott

#3 (permalink)   05-22-2008

bhaski Contributing Member   Join Date: Apr 2006 Location: kolkata(now in noida) Posts: 56 Thanks: 9 Thanked 3 Times in 2 Posts

Re: How can I get records in follwing format? there r many ways 2 do this http://asktom.oracle.com/pls/asktom/...D:766825833740 or search google pivot query

Geeks Talk > Databases > SQL

« Different Outputs for Max() Function | updating records »

Thread Tools

Show Printable Version Email this Page

Display Modes

Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
pls let me know the answers for follwing lr questions	vsmkreddy	LoadRunner	1	05-16-2008 08:29 AM
Report output Format to pdf format	krishnaindia2007	Oracle	2	02-05-2008 03:49 AM
Currency Format	krishnaindia2007	Oracle	1	12-27-2007 02:46 AM
Format of Sysdate	Geek_Guest	Oracle	5	07-12-2007 06:04 AM
How can I display the records in specific format	anandreddy.bv	SQL	1	05-30-2007 05:50 AM

All times are GMT -4. The time now is 06:30 AM.