Home » SQL & PL/SQL » SQL & PL/SQL » Query
Query [message #190746] Fri, 01 September 2006 02:03 Go to next message
sam4all
Messages: 29
Registered: August 2006
Location: Bangalore
Junior Member
Hi

I has table with data like Sachin tendulkar,Rahul dravid,saurav ganguly all are varchar2.i want query to display
s tendulkar,r dravid or sachin t,rahul d .
Plz help me
oracle 9i is using
regards,
SAM CHACKO
Re: Query [message #190790 is a reply to message #190746] Fri, 01 September 2006 04:43 Go to previous message
dw_mmr
Messages: 12
Registered: July 2006
Junior Member
try soemthing ike this


SQL> create table MM_test ( a varchar2(20));

Table created

SQL> insert into MM_TEST values ( 'Rahul Dravid' );

1 row inserted

SQL> insert into MM_TEST values ('Sachin Tendulkar');

1 row inserted
select lower(substr(a,1,1)) || ' ' || lower(substr(a,instr (a , ' ' ))) from MM_TEST;

LOWER(SUBSTR(A,1,1))||''||LOWE
------------------------------
r dravid
s tendulkar
Previous Topic: SQL script: loop through a dynamic list of sql scripts?
Next Topic: size of database
Goto Forum:
  


Current Time: Wed Dec 07 22:29:20 CST 2016

Total time taken to generate the page: 0.10932 seconds